Hi everyone,
I’ve looked around the whole day, and I can’t seem to find an answer to what would seem like a pretty straightforward question.
I’m using Grafana with InfluxDB.
I have two different queries, query A and B, which are then grouped by group1, group2, etc.
When I look at the individual results of the query by activating just one, I get what I expect, whether it be formatted as Time series or Table.
But once I try to combine the two as a Table, then everything breaks, and the values are not associated with the proper columns!
Here is an example:
- Query A - Time series (as expected)
Metric | Value
Col A {group: group1} | 1
Col A {group: group3} | 2
- Query A - Table (as expected)
Group | Col A
group 1 | 1
group 3 | 2
- Query B - Time series (as expected)
Metric | Value
Col B {group: group1} | 3
Col B {group: group2} | 4
Col B {group: group3} | 5
Col B {group: group4} | 6
- Query A - Table (as expected)
Group | Col A
group 1 | 3
group 2 | 4
group 3 | 5
group 4 | 6
- Query A+B - Time series (as expected)
Metric | Value
Col A {group: group1} | 1
Col A {group: group3} | 2
Col B {group: group1} | 3
Col B {group: group2} | 4
Col B {group: group3} | 5
Col B {group: group4} | 6
- Query A+B - Table (what!?)
Group | Col A | Col B
group 1 | 1 | 3
group 2 | 4 | -
group 3 | 2 | 5
group 4 | 6 | -
It looks like all empty cells are removed from the row and everything is shifted to the left.
For comparison this is what I would expect as the final Table for both queries:
Group | Col A | Col B
group 1 | 1 | 3
group 2 | - | 4
group 3 | 2 | 5
group 4 | - | 6
Does this have something to do with the queries? (But why is the time series correct?) Or could this be a bug with the Table representation?