State timeline from matrix grouping transformation: "Data does not have a time field"

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

Cloud

  • What are you trying to achieve?

I used the following data transformation on the query result

image
image914×78 7.85 KB

The resulting table has a row for each timestamp with a column for each grafana instance. The value of each cell is used to define the state of the grafana instance.

image
image1096×247 56.7 KB

I want to create a state timeline from this data

  • How are you trying to achieve it?

Creating a state timeline visualization

  • What happened?

I get an error “Data does not have a time field”

  • What did you expect to happen?

The data be displayed as a state timeline for each instance (column)

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

I get an error “Data does not have a time field”

  • Did you follow any online instructions? If so, what is the URL?
2

The solution was to add one additional transformation step setting the startTime field type as Time (probably this was lost in some previous transformation)

image
image861×148 14.2 KB