I’ve been having this issue for quite some time now with Influx. When separating data by tags, in my case ‘Companies’, the charts don’t display information correctly.
This chart use to display information, however now it does not anymore. The chart has a Y-Max of 0, since I only wish to display negative values.
SELECT difference(SumOfBookings) FROM (SELECT sum(finishedBookings) AS SumOfBookings FROM (SELECT sum(businessBookings) + sum(privateBookings) AS finishedBookings FROM dailyBookings WHERE ("adminGroup" = 'someAdminGroup') GROUP BY time(1d)) GROUP BY time(30d)) GROUP BY company
Another example of this issue would be this chart:
Which uses this query:
SELECT difference("activeUsersPerMonth") FROM (SELECT mean("activeUsersPerDay") AS activeUsersPerMonth FROM (SELECT sum("total") AS activeUsersPerDay FROM "users" WHERE "adminGroup" = 'someAdminGroup' AND $timeFilter GROUP BY time(1d)) GROUP BY time(30d))
If I simply try to group them by “Company” (i.e. add GROUP BY company), I get this:
It seems that the stack functionality of the bar charts does not work as expected. The hover tooltip is displaying the correct numbers, but the charts don’t Stack correctly. Anyone have an idea about this?