7 Replies Latest reply: Nov 26, 2014 11:57 PM by Ashwani Kumar RSS

    Stacked chart with calculated cycle

      Capture.PNG.png

       

      Hi!

       

      I'm trying to create a chart that shows the number of sites divided by their status. The thing is that one site has multiple machines and the status comes from the machines so one site might have multiple statuses. The problem is shown in the picture. There is only one site in the picture but because it has to statuses the chart shows that their is two sites. Is there an expression I could use or some other way to create this kind of view so that the total amount of sites wouldn't be duplicated but all the statuses would show? I would like it still to be like this horizontally.

       

      At the moment the expression of the chart is just COUNT(DISTINCT([Site Code])).

       

      Thanks for your help!

       

      Regards,

      Heidi