How can I convert a Time typed column to timestamp to have a numeric value for alerting?

[martonivan]

I would use a GraphQL result for alerting. The goal is to monitor the age of an object given in absolute time. The selection and the parsing of the string still works, but I've found no way to:

• exclude the later stringified time column
• format the time value and calculate a timestamp from that column

The selector gets: "2025-07-07T11:25:07Z"
If the format of that column is set to Time, this value is converted to: "2025-07-07 13:25:07"

But this is still unsuitable for the Grafana to have an alert set up for, since that accepts numeric values only. Is there any way to implement this using Inifinity?

[yesoreyeram]

Did you get a chance to look at https://community.grafana.com/t/configure-alerting-using-infinity-tabular-data/149967/5 ? Not 1:1, but that may give you some idea

[martonivan]

Thank you for leading me towards JSONata, this solved my issue. Using the $floor(($toMillis($now())-$toMillis(data.<JSON path>))/1000) transformation provides me not just the timestamp in numeric value, but that being transformed into the age that I was looking for at the end!

[yesoreyeram]

Nice. One small info. instead $now(), you can use dashboard time range macro ${__timeFrom} which will help you to align with the dashboard time range.

https://grafana.com/docs/plugins/yesoreyeram-infinity-datasource/latest/query/macros/#time-macros-__timefrom-and-__timeto