Display color based on if > Yesterday = Green

[j0jje]

Hello, i am pretty new with Grafana Dashboard.

We use InfluxDB DS923.
I want to display that if value on “Orderstock” is bigger than Yesterday to be green.

i cant seem to find anything. Just color based on a min/max value which does not work.

anyone that has solved a problem like this?
Snip from the value that i want to change color based on changes from the day before.
The visualization is now Stat.

[infofcc3]

Hello @j0jje, I tried based on the min/max value maybe it will be helpful for you. Using Grafana transformations, first i used the ‘Organize fields by name’ transformation to hide the unwanted fields not necessary( optional transformation)

then use transpose transforamtion for all values in one row

Then finally, use ‘Add field from calculation’ to calculate the max value in the row

Now you can use ‘Add override’ and set the override on the max value field it will work for you like this…

[yosiasz]

are you using flux or influxql query language? if you are on the new version of grafana (12) there is a new private preview feature you could leverage

[feature_toggles]
enable = sqlExpressions