Please avoid posting in the Grafana parent category. Whenever possible choose a subcategory.
How can I show Temperature Values range in this with a small value indicator for Humidity .
~ the grafana team
The Stat panel with sparkline can only reference the same query, so you cannot use it to display temperature and humidity.
Any Suggestions what I can use with InfluxDB to represent multiple data
I see this Value with my influxDB Query
how can i get this dropped from the UI
My InfluxDB Query is
from(bucket: “general”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “mem”)
|> filter(fn: (r) => r[“_field”] == “device_temperature”)
|> group(columns: [“host”])
|> map(fn: (r) => ({r with host:
if r.host == “” then “”
else if r.host == “BC572903F1F3” then “COLD POINT-F1F3”
else if r.host == “BC572903F1B8” then “HOT POINT-F1B8”
else “”}))
|> drop(columns: [“_field”, “device_temperature”])
|> drop(columns: [“_field”, “clockin”])
|> drop(columns: [“_field”, “gateway_insert”])
|> drop(columns: [“_field”, “location”])
|> drop(columns: [“_field”, “history”])
|> aggregateWindow(every: 5m, fn: mean, createEmpty: false)
|> yield(name: “mean”)
Just to clarify your question above, are you wanting to remove the 20.9 in your gauges, like this?
Yes
Does adding this after your aggregageWindow function do anything?
|> drop(columns: ["_value"])
Going back to your original query (without the drop(columns: ["_value"]) statement), could you obtain the desired result using some Transformations, like this?
BEFORE:
AFTER:
By Hiding this works !!
Closing this thread for the original question.
New question on alerting here: Customized Alert based on Criteria