Dealing with InfluxDB result and table panel

Grafana Table Panel
,
1

  • What Grafana version and what operating system are you using?
    Docker on v8.3.1

  • What are you trying to achieve?
    Table of multiple field Last values from influxdb query so all 7 fields are displayed as columns for a given tag.

  • How are you trying to achieve it?
    Pivoting the influxdb query around a tag variable.

  • What happened?
    One row in my table, with columns correct, and a selector for each tag value at the bottomw of the table.

  • What did you expect to happen?
    Not really sure… how exactly Grafana interprets the results from Influx is still a mystery to me… I really want a single table with all stations visible simultaneously.

  • Can you copy/paste the configuration(s) that you are having problems with?

from(bucket: "cah2") 
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> toFloat()
  |> last(column: "_value")
  |> map(fn: (r) => ({ r with _measurement: r.stationName }))
  |> group(columns: ["_measurement"])
  |> pivot(rowKey:["_measurement"], columnKey: ["_field"], valueColumn: "_value")
  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No.
  • Did you follow any online instructions? If so, what is the URL?
    No.

When I try to apply a Merge transformation I get all the rows, but then they don’t have a station name on each row…

2

Does your flux query produce the desired table when run in InfluxDB Data Explorer?

3

Regular table, no.
Simple table, yes.

4

f me.

Flux : Blue Apron ; |> group() : scallions as a topping.
Seriously… why does group() always have to be used.

If you find this thread, just add a |> group() at the end.

3 Likes