Grafana Zabbix Querying (Getting number of values meeting condition)

  • What Grafana version and what operating system are you using?
    6.5.3.

  • What are you trying to achieve?
    Example, I want to get the number of servers which have a CPU utilization of over 90%, in a single host group. I tried to use the “removeBelowValue” function to remove values under 90%, and then used the count function to get the count, but the “removeBelowValue” doesn’t actually remove/filter values, it just changes them to “null”. So doing a “count” function is not accurate/does nothing since the results under 90% never get filtered.

The only “filter” functions I see that actually remove values are “bottom/top”, but in my case, I want a “count”, instead of top xx values or bottom xx values.

  • How are you trying to achieve it?

  • What happened?

  • What did you expect to happen?

  • Can you copy/paste the configuration(s) that you are having problems with?

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

  • Did you follow any online instructions? If so, what is the URL?