Grafana 11.4
Zabbix 7.2
I have these Zabbix items that are sort of duplicates.
They are identical items with the same value, but from different hosts, since the hosts are replicas of each other.
When I plot the item values in the Grafana Stat panel, the values are duplicated as well.
Now, I need to “deduplicate” them, but I can’t find a transformation that does this.
If Grafana finds an item with the same name, it should display only one of them, no matter the host.
Is there a way do this?
Hi, have you tried “Group by” transformation? You could group by the host and ignore the other fields?
1 Like
Thanks for the reply, guys.
I could not find a “Group by” option for host. If I were to use the “Group by” transformation, I would need to manually “group” all the individual items from a single host. If the host stopped working, I suppose the values would be absent from Grafana.
My goal is to query both Zabbix hosts and display only one set of items, regardless of the host.
I finally found a way to deduplicate the items just by adding a Join by labels transformation.
Since all the items are series, using “Join” just works.
I’ll test to see if the values will remain valid when a host stops working, but it’s working for now.
Thanks for all insights.
2 Likes
