I have recently been introduced to grafana to build a few reports and dashboards for our team. I have not been able to get the stacked bar graph working and was wondering if they are not fully implemented or there are some tricks to get them working. The same data in excel works perfectly.
this is what I like to achieve …
now() as time
, count()FILTER (where vitaminC=1) as VC
, count()FILTER (where vitaminD=1) as VD
, count(*)FILTER (where vitaminE=1) as VE
group by fruit
and like to generate a stacked bar graph where groups are stacked on top of each other, see attached excel example. the datasource is postgres but I don’t believe that matters. I would greatly appreciate if you could provide some insight. thank you!