Hi,
I have a chart that looks like this: It is a chart that shows the current value, baseline, warning and threshold of a metric. The requirement is to colour the area above the red line with red. The line about amber with amber and everything below amber with green. I tried area chart however that colours below the lines and not above.
My query returns data like this:
_time Baseline Average Critical Payments Today Warning
2018-10-29 14:20:00 67.2 161 28 108
2018-10-29 14:10:00 63.28 166 27 107
2018-10-29 14:00:00 49.57333333333333 141 27 89
2018-10-29 13:50:00 41.10666666666667 120 27 75
2018-10-29 13:40:00 39.733333333333334 121 27 75
2018-10-29 13:30:00 36.72 127 27 75
Anybody done this before?