7 Replies Latest reply: Feb 14, 2018 8:58 AM by Anil Samineni RSS

    Two dimensions, two expressions, stacked bar and line chart?

    Keith Curley

      Dear community,


      I have a combo chart with two dimensions, Month and Sub-WorkCentre.


      The first of my expressions is a stacked bar chart which simply sums the output Hours per Sub-WorkCentre.


      In my second expression I want to show a total capacity line for Main-WorkCentre. We only record capacity at the Main level, the expression is below:

      sum(TOTAL <Week> {<Activity={'Capacity'}>} Hours)


      However when I try to apply this my stacked bar chart turns to a grouped bar chart with the total capacity line.


      Is there a way to get my first expression to stack?