Convert epoch metric to datetime

[rickylavareda]

Hi,

I want to have a dashboard where I can see what was the last date/time a record was processed. I created a metric that is exposed to Grafana by Prometheus that has Epoch time of last date/time a record was processed

I want to convert the timestamp to date/time (eg. DD-MM-YYYY HH:MM:SS), can someone tell me how to do it? I searched for some ways of doing it but none of them worked

Thank you

[fercasjr]

Depending on your Grafana version it should be an option to convert to time:

[rickylavareda]

I tried but No Data appeared

[fercasjr]

could you toggle table view to see the raw data? also which panel type are you using and what options have you selected on? is it single stat? did you selected which values to show? I believe by default shows all numeric or _value values, and you are trying to show other, in this case “time” or maybe should be “string” ? (not sure how it is managed on Grafana UI)

[rickylavareda]

This is table view

[clevernessisamyth]

Hello,

have you tried changing the unit?

Either via Standard Options

Or, override only the unit of that field

[rickylavareda]

It worked by changing the unit

Thank you for your help

[clevernessisamyth]

Glad it worked!