1 Reply Latest reply: Mar 28, 2017 9:54 PM by Sunny Talwar RSS

    How can I create a stacked bar chart with two measures that add to the correct total?

    Elise Reiter

      I want to create a stacked bar graph that displays:

       

      1) Total installations by town

      2) Total installations with missing data

       

      The issue I'm running into now is that when I add both measures separately, it is counting each separately, which makes it look like the total installations are more than they really are

       

      For example if there was 1 installation done with missing data, the stacked bar graph is showing a count of 2 - 1 installation and 1 installation with missing data when I would like it to just show one bar in red that indicates 1 installation was done with missing data

       

      The current expressions I'm using are:

       

      1) count([Installations])

      2) sum([BlankFields)]

       

      BlankFields is a field I created in the data load editor that is like this:

       

      if((ManufSerialNo.='' OR Manufacturer='' OR ConstructYear='' OR "Valid From"=''),1,0)as BlankField

       

      How can I create a graph where the totals sum to the total number of installations?