Hi, I use this query: SELECT time, sensor_id AS metric, "measure_value::double" FROM "sensordb"."temp" WHERE "measure_value::varchar" IS NULL and sensor_id IN ( '28-02149245a540', '28-02159245c2cf', '28-3ce1045708a9', '28-3ce104572746' ) ORDER BY time DESC LIMIT 20 With the “Prepare Tim…

Thank you: I found the answer here: Effective queries for common query patterns in Amazon Timestream | AWS Database Blog My query looks like this now: SELECT sensor_id ,max_by(time, time) AS time ,max_by("measure_value::double" , time) AS value FROM "sensordb"."ruesselsheim" WHERE "measure_val…

Only the 4 ids which you can see in the upper query.

I created a screenshot to make my question more “clear” [test] I want to “label” the red marked text for each gauge and I want to set different colors for each gauge. Thank you :slight_smile:

[image] madmoses: "measure_value::double" Make the above to be "measure_value::double" as value

No I have there something like “value 28-3ce1045708a9” for each gauge. But I would like to write a custom label. For example “Watersensor”, “Heatersensor” … Is this possible?

Is the value in the database value 484847384u3 What is your datasource? Mysql?

I use aws timestream. Is the value in the database value 484847384u3 No, this value is not in the database. Where is it from?

It was just an example :eyes: Is the value in the database Actually has the string value in it? value 28-3ce104572746”

This is the value in the database: “28-02149245a540” This is also the value which I use in my “WHERE” part of the SQL query.

How to change the labels and color of the gauge panel?

Grafana Gauge Panel

phil June 5, 2023, 2:43pm 8

It is not working. What I am doing wrong?
(I tried it with “value 28-3ce104572746” and “28-3ce104572746”)

Thank you so much

Topic		Replies	Views
Gauge bar with custom (dynamic) label? Gauge Panel value-mapping	6	2600	May 16, 2023
Multipe lines in timeseries using AWS Timestream Dashboards	5	453	May 31, 2023
Show value of a field and set threshold color based on another field Gauge Panel plugins	4	3552	May 25, 2024
Change appearance of Gauge panel based on a second metric Gauge Panel	2	402	September 28, 2023
Bug in Bar and Gauge Value Mappings Grafana bugreport	10	626	November 11, 2024

How to change the labels and color of the gauge panel?

Related topics