Grafana 10.3.3 Data-source Zabbix I have a stat panel that displays multiple string values of either “Ended OK”, “Ended Not OK” or “Executing”. [image] From the main query, I need to count how many are of each value and display this in another panel. Something like 10 Ended OK 3 Ended Not OK …

Finally, I was able to count all values by each state. A combination of Reduce, Group by and Rows to fields transformations were necessary, followed by a Add field from calculation just to sum all values. [image] It is now what I had in mind. [image] Thank you all for your efforts to help me…

Count unique values from stat query

Grafana Zabbix

sowdenraymond February 23, 2024, 7:39am 2

starting with some dummy data:

and then two transformations:

1 Like

Topic		Replies	Views
SingleStat with Zabbix Triggers Stat Panel zabbix	0	1578	May 13, 2019
Did not get the text metric from Zabbix Configuration zabbix	6	3055	January 15, 2021
Dynamic table view from Zabbix Dashboards plugins , polystat , dashboard	5	6445	March 2, 2023
How to count only filtered data? Zabbix api , zabbix	3	1314	November 2, 2020
Two different series, in same panel, each one being the sum of multiple different queries Zabbix	6	1170	February 21, 2024

Count unique values from stat query

Related topics