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?
