SELECT time, sensor_id AS metric, "measure_value::double"
WHERE "measure_value::varchar" IS NULL and
sensor_id IN (
ORDER BY time DESC LIMIT 20
With the “Prepare Time Series → Multi-Frame Time Series” transform.
I want to set for each “sensor_id” my custom label and change the color for each Gauge to my personal custom value? (For example red, blue, …)
How can I do this?
Is it correct that I have to structure the order of my gauge in the sql query? How would you do this?
that is not possible. there are a few things not making sense with your visualization
you have time series readings for different devices but you want to show them in gauge visualization. In this case your time column is really not useful as you will not see that value but now it creates way too many gauges since there many time series of data for each sensor. You will need to figure what visualization you want to use if time is involved. but if you insist you want to use gauge then time column is throwing things off. hence you might maybe need to get the latest reading for each sensor.