Hello
I want to create a bar gauge where 0 is in the middle (excess power in a PV), -10000 on the left and +10000 on the right.
But - when I have a value of 0, I want the bar to show nothing. When I have -5000, I want the bar starting in the middle and showing from 0 to the left to -5000.
Is it possible?
CoPilot tells me to do this:
" * Bar orientation: Adjust the bar orientation so that negative values extend to the left. You can do this in the “Display” section by setting the “Orientation” to “Horizontal” and ensuring the “Reverse” option is enabled for negative values."
but I cannot find this reverse option
Thanks
@DominikReber
You mean something like this?? For this you can use the ‘Bar Chart’ Plugin
Its covers most of your criteria but not all.
1 Like
I was able to get this with the bar chart plugin. Result:
What I have done:
-
Created multiple queries for each data channel just like in a bar gauge. Important here is that the query selects just the last value from the resulting time series:
-
As a workaround, added another query that just returns any value. We need it later to get rid of the time dimension:
-
Add a ‘Reduce’ and a ‘Rows to fields’ transformation like this:
-
In the Bar Charts options:
- Bar chart
- X Axis: Use the superfluous query that we added as workaround. This will disable the time dimension.
- Orientation: Horizontal
- Axis
- Placement: Hidden
- Centered zero: Enabled
- Soft min: -5 (-5000 in your example
- Soft max: 5 (5000 in your example)
Hope this helps.
1 Like
