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.
If you disable transformations, do you still have 40 rows?
I have 2 transformations active.
The row totals, no changes if removed
Merge series/tables, if I remove this one I only see a single with a drop down box to select each row. And I want to see all rows together. This transformation has no option for limits etc.
If I understand the debug correctly I would need to see 110 rows instead of 40.
Debug from the merge transformation:
Input data
Array[110]
0:Object
name:“logging”
refId:“A”
meta:Object
typeVersion:Array[0,0]
executedQueryString:“from(bucket: \“bucket\”)
fields:Array[34]
0:Object
1:Object
2:Object
3:Object
4:Object
5:Object
6:Object
7:Object
8:Object
9:Object
10:Object
11:Object
12:Object
13:Object
14:Object
15:Object
16:Object
17:Object
18:Object
19:Object
20:Object
21:Object
22:Object
23:Object
24:Object
25:Object
26:Object
27:Object
28:Object
29:Object
30:Object
31:Object
32:Object
33:Object
length:1
1:Object
name:“logging”
refId:“A”
fields:Array[34]
0:Object
1:Object
2:Object
3:Object
4:Object
5:Object
6:Object
7:Object
8:Object
9:Object
10:Object
11:Object
12:Object
13:Object
14:Object
15:Object
16:Object
17:Object
18:Object
19:Object
20:Object
21:Object
22:Object
23:Object
24:Object
25:Object
26:Object
27:Object
28:Object
29:Object
30:Object
31:Object
32:Object
33:Object
length:1
2:Object
name:“logging”
refId:“A”
fields:Array[34]
0:Object
1:Object
2:Object
3:Object
4:Object
5:Object
Output data
Array[1]
0:
fields:Array[34]
0:Object
1:Object
2:Object
3:Object
4:Object
5:Object
6:Object
7:Object
8:Object
9:Object
10:Object
11:Object
12:Object
13:Object
14:Object
15:Object
16:Object
17:Object
18:Object
19:Object
20:Object
21:Object
22:Object
23:Object
24:Object
25:Object
26:Object
27:Object
28:Object
29:Object
30:Object
31:Object
32:Object
33:Object
first:Array[40]
0:0
1:1
2:3
3:2
4:3
5:2
6:1
7:2
8:2
9:1
10:0
11:0
12:1
13:3
14:10
15:0
16:0
17:3
18:1
19:1
20:1
21:2
22:2
23:5
24:2
25:0
26:3
27:1
28:2
29:1
30:1
31:2
32:10
33:2
34:2
35:2
36:1
37:2
38:2
39:2
parsers:undefined
creator:g=>g??
refId:“merge-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A-A”
length:40
gyrogearloose23:
Merge series/tables
So probably this is the reason. From transformation help :
This transformation merges values into the same row if the shared fields contain the same data.
If you add |> group() to the end of your query, would you get the same result in InfluxDB UI and Grafana?
