-
I’m using grafana 12.2.1, running in a linux docker on a windows machine. InfluxDB is hosted in a seperate docker container on the same machine.
-
What are you trying to achieve? I’m trying to create a table view, with totals at the bottom.
-
How are you trying to achieve it? InfluxDB is filled from a seperate system with records consisting of a uniqueID and multiple fields with bytes.
-
What happened? InfluxDB data viewer shows all rows that are present in the bucket. But if I run the same query in Grafana for a table panel it is limited to 40 rows.
-
What did you expect to happen? All rows to be visible
-
Can you copy/paste the configuration(s) that you are having problems with? Query in question: from(bucket: “bucket”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“_measurement”] == “logging”)
|> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: false)
|> pivot(rowKey:[“uniqueId”], columnKey: [“_field”], valueColumn: “_value”)
|> yield(name: “uniqueId”)
-
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were. No error visible
InfluxDB output:
Grafana output:
See that InfluxDB shows 55 rows availble, Grafana only shows 40, regardless of the amount in the bucket.