I need to build a stacked bar graph with data grouped not by time.
I got data with a query:
SELECT "count" FROM "autogen"."AverageTravelTime" WHERE ("unique-run-name" =~ /^$run_name$/ AND "mode" != 'all-car') AND $timeFilter GROUP BY "mode", "iteration-num"
I want to build similar stacked bar graph but with value of “iteration-num” tag in X axis:
The problem is I can’t force grafana to stack bars when data grouped not by time.
This checkbox just does not change anything:
Any help appreciated!