Invert Time Series Panel graphs in Grafana so smaller values are higher on the Y-Axis

Grafana Time Series Panel
1

Hello all,

I am using Grafana version v10.0.1 and I want to show the values on Y-Axis of my Time Series Panel so the smaller values are at the top and the larger values at the bottom.
I have searched the forums, but couldn’t find a solution to my problem.
Can anyone help me to invert Time Series Panel graphs in Grafana so smaller values are higher on the Y-Axis?

I found 2 half solutions to the problem, but both cause the Y-axis values to be shown as negative numbers which I want to solve.
The first solution is multiplying the query result with -1, while the second solution is using a an Override property for Graph styles Transform for all values fields and setting the Negative Y value as shown in the picture below.

image
image1813×296 15.8 KB

Thank you

2

Hi,

There’s either the thing you’re already mentioned (the -1 multiplier), since that’s one of the mathematically correct way to show low values high. Unfortunately they will stay negative and there’s not much that can be done.

Another method would be to calculate max / some high value - current - then the low values would be on top but I don’t think it would be too readable.

3

Thank you for the proposition, but unfortunately as you said it won’t be readable for our client.

4

Look at this graphs here

Available via Business Chart plugin