0 Replies Latest reply: Jun 5, 2012 3:20 AM by juerg maier RSS

    grouped bar chart with 3 dimensions

      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