Changing query bar colors

Grafana Time Series Panel
1

Hello everyone,

I would like to know if it is possible to change the bar colors in a panel that are resulting from multiple queries.

I am measuring daily energy consumption and would like to see when consumption has exceeded certain thresholds. So far I have managed to get the graph to display as follows:-

image
image803×288 11.3 KB

The queries I have used are:-

SELECT max("value") FROM "$" WHERE ("entity_id" = 'energy_cost_daily' AND "value" < 7) AND $timeFilter GROUP BY time(1d) fill(none)

SELECT max("value") FROM "$" WHERE ("entity_id" = 'energy_cost_daily' AND "value" <= 5) AND $timeFilter GROUP BY time(1d) fill(none)

SELECT max("value") FROM "$" WHERE ("entity_id" = 'energy_cost_daily' AND "value" <= 4) AND $timeFilter GROUP BY time(1d) fill(none)

The data is as follows:-

image
image803×357 20.3 KB

Ideally, I would like for anything below 4 to display as green, anything between 4 and 5 to display as yellow and anything above 5 to display as red.

I have tried using series overrides but the only value that seems to be available to customize is 3 instances of $.max. As soon as I override one of them, the entire bar changes to that color.

Any ideas?

Thanks

2

Series overrides looks like this:-

image

3

Resolved this.

I figured out how to use Alias.