I have normally a time and category dimension to show my data in a bar chart
I have been asked to show a grouped bar chart for some special cases, let me call it "Fixed". I have added a Flag (0/1) in the fact table to represent "Fixed".
I can show the bars with the expression sum( if(Fixed = 1, Value, 0))
This however will not filter my lists based on the "Fixed" setting when I select the bars.
If I add the "Fixed" flag as a dimension and use sum(Value) as expression the filtering works but now the grouped bar chart automatically turns into a stacked bar.
Do I need to create a concatenated dimension "category + Fixed", a calculated dimension or is there a setting to force the grouped bars?
Juerg