7 Replies Latest reply: Feb 14, 2018 8:58 AM by Anil Babu 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?

       

      Thanks,

      Keith