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	1581	May 13, 2019
How to count the number of records with specified condition on fields in SingleStat panel Grafana	0	2123	April 15, 2018
Did not get the text metric from Zabbix Configuration zabbix	6	3106	January 15, 2021
Add up values from multiple sources Grafana	2	610	November 8, 2017
How to count only filtered data? Zabbix api , zabbix	3	1339	November 2, 2020

Count unique values from stat query

Related topics