Format As Table with Multiple Queries wrong representation

Grafana InfluxDB
1

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?