How to convert Time in Series joined by time to a real time value

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

  • What are you trying to achieve?
    Make the “Time” column in Inspector–>Data (with Data Options set to “Series joined by time”) be an actual clock time (corresponding to the time that appears in the graph when not in “Inspector” mode).

For example, if I run a query, by default I see a nice time series graph with a “Table” below that displays the “Time” in the format: YYYY-MM-DD HH:MM:SS

This is great.

But then when I switch to “Inspector” mode and then click on the “Data” tab, the “Time” column has values like: 1682447281000

Then if I download to CSV, I get these same 13 digit time values.

How can I convert a time that looks like: 1682447281000 to a format like YYYY-MM-DD HH:MM:SS?

I don’t have to convert the time in Grafana itself (have tried various conversions in Excel when I open the downloaded CSV) but just need the resulting CSV data to format the time in a readable time format.

I figured it out. Those times are in EPOC format so I can convert them in Excel using a formula.

1 Like