Grafana v10.1.2
Data-source Zabbix 6
I have a dashboard that displays several metrics and they are somewhat balanced.
Using a percentage threshold, I can change its color to red whenever a value is 0.
If a value is too high or too low compared to the others, I need it to change color as well.
In the previous image, one of the values is 22, which is higher than the other values. Therefore, I need to highlight it.
So, as I understand it, the default percentage threshold is relative to the min and max values.
Is there a way to make this percentage threshold relative to the average value?
Nothing?
To make it clearer, the default percentage threshold is relative to the min and max values of the same series.
Is there a way to make this percentage threshold relative to the last value average of all series?
Basically, I wanted to highlight the outliers.
Did you figure out a way to do this? I’m looking to do the same thing pretty much
what is your datasource and how do you define something as being too high or too low? is it a % or some other calculation
here is a test harness using mssql to show percentage difference
Thank you for your return.
As I said, it is a Zabbix 6 data-source.
I originally wanted to set the thresholds to a fixed high and low percentage, but haven’t found a way to do that yet. (other priorities).
The color scheme does help to highlight the value differences, but it seems to only go in one direction.
I mean, if there was a scheme like Red - Green - Red.
For example:
In my initial example, we have a set of 19 values (series).
All values average is 8.63, including zeros. Let’s say I set a threshold of 30% difference.
- Only a series with the last value equal to or greater than ~12 should trigger the higher threshold and be highlighted.
- On the other hand, only a series with the last value equal to or less than ~6 should trigger the lower threshold and be highlighted.
Hello, just wanted to check, does my solution work for you, or are you still facing same issues Please contact me if you need any help, I will be happy to help you here!
Hi @infofcc3 .
I don’t think this applies to the scenario I have.
Your proposed data-source is different and the “config from query results” transformation does not provide a query.
