Flux - Timeseries with Group by - Data is missing a time field

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

Using grafana and influxdb on docker: grafana/grafana:10.0.5 influxdb:2.7

  • What are you trying to achieve?

Visualize the history of CI unittest results.

  • How are you trying to achieve it?
from(bucket: "junit")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "junit_data")
  |> filter(fn: (r) => r["_field"] == "test_name")
  |> filter(fn: (r) => r["project_path"] == "${project}")
  |> group(columns: ["build_number", "test_status", "_time"])
  |> count() 
  • What happened?

While the InfluxDB Data Explorer shows the results as expected with _time, build_number, _value and test_status as fields (or tags?), the Time Series visualization in Grafana shows “Data is missing a time field”.
Switching to the Table view, the only column available is the value (count as expected) with a column name like _value{_time=“xxxx”, test_status=“FAILED”, …}

  • What did you expect to happen?
    Visualization of the State/Value over time.