Zabbix – Show only alerts triggered more than 40 minutes ago

Hey guys, I’m trying to create a panel in Grafana that only shows Zabbix alerts that were triggered more than 40 minutes ago. I’ve been trying to figure this out for over a week and I’ve reached a point where I don’t know what else to test. What I’ve already tried:

I use the Infinity plugin as a datasource (JSON). I make the call to the Zabbix API using the problem.get method. Then I apply Grafana transformations to try to filter and convert the data.

Where the problem is: The main blockage is converting Unix epoch time (the ‘clock’ field returned by the API) and filtering by minutes (showing only alerts that are more than 40 minutes old). I can’t get the transformation to reliably calculate the time difference and filter correctly. Has anyone encountered a similar scenario or knows how to solve this (whether with a Grafana transformation, Infinity query, or even another approach)? Any tip, query example, transformation, or reference link would help me a lot. Thank you in advance for your attention, and I’ll be waiting for any help! :folded_hands:

I understand your problem. I’m currently working on a solution for it and will get back to you shortly.

1 Like

I will be waiting for you, I thank you greatly!

please try …
Grafana Transformations
Add field from calculation → convert clock to milliseconds (clock * 1000)
Convert field type → set it as Time
Calculate age (difference) → compare with current time