AnsweredAssumed Answered

How Can I Create A Stacked Bar Chart From A Summary Field and Product Field

Question asked by MrMunchkin on Jul 11, 2013
Latest reply on Jul 11, 2013 by MrMunchkin

Title

How Can I Create A Stacked Bar Chart From A Summary Field and Product Field

Post

     Hi,

     I am trying to create a stacked bar chart from a summary field and a product field to show up in a dashboard layout. 

     I think what I am trying to accomplish is simple, but that I just don't know the correct syntax to be able to filter the chart. 

     Here is what I have:

     Product Field - in here there are two types of product A and B

     Summary Field - is a summary of the total cost of product Field

     Date Field - showing dates

     Month Sort Field - showing months

     I can create a normal bar chart which shows the combined total of A + B in per month. This works perfectly.

     However, I would like to show it on a stacked bar chart where I can see the individual total for A + B.

     Does anyone know how to do this? I would appreciate any help.

     Is it done with a calculation from the chart screen for the X or Y axis? Is it something to do with the way the data is sorted?

      

Outcomes