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…

starting with some dummy data: [image] and then two transformations: [image]

Hey. Thanks. I tried to use these transformations, but the thing is that each value shown is a field. So “Group by” does not really group all the fields, just the values from those fields. [fields]

Hi @markfree Can you write a Zabbix query to do counting? I think the solution proposed by @sowdenraymond is perfect given what you initially described, but obviously the actual query behind your stat panel has more info that we were initially led to believe. Can you share the full query here?

Unfortunately, I don’t think the query is customizable to count values. The query is very simple, actually. [job_query] It results in multiple data sets that are filtered and used in different panels. [query_result]

[image] markfree: up all the fields, just the values from those fi can you show a table view of your data please?

Yes. [query_table] In the table view, I can toggle the data in the selection box below.

can you try the concat transform to put all the data into one table?

When I add the “Concatenate fields” transformation, the panel shows different values, and not the last one. [concat_transf] [concat_jobs] It separates the fields as columns.

Best option: on Zabbix side (if it’s 5.4 or newer) creating some “ Aggregate calculations ” would be easier. If you need to make it work on Grafana’s side, try to play around with this set of transformations on a table view: Reduce “Mode” using “Series to rows” “Calculations” using “Last *” Enable…

Hey Isaque. Thanks for your help. Unfortunately, Zabbix does not support aggregations for these items because they are string values, not numbers. All of this looks to me like a frequency distribution and the status values are the actual classes. When I add the Reduce transformation, this is wh…

Count unique values from stat query

Grafana Zabbix

sowdenraymond February 23, 2024, 7:39am 2

starting with some dummy data:

and then two transformations:

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

Count unique values from stat query

Related topics