3 Replies Latest reply on Jul 31, 2018 4:35 AM by devon.medlin

    Add labels as a % of month to stacked bar chart

    devon.medlin

      I'm having an issue changing a label from a whole number to a percent in a stacked bar chart (please see the attached file).

       

      If you take a look at the data source you can see that there are 10 rows of data (5 for each month).

      Id = 1 appears twice during Jan 2018. I bring this up because the data set that this is based off is structured in the same way.

       

      I would like to change the whole numbers for the labels on sheet 1 to percentages.

      With that change January 2018 should have the blue part = 75% and the orange part = 25%.

      February 2018 should have the blue part = 40% and the orange part = 60%.

       

      I attempted to make this change on Sheet 2 but ran into the following error "Cannot find a total needed to compute a percentage. The database may have changed or a calculation cannot be compiled. Try refreshing your connection or editing the calculation."

       

      Help resolving this problem would really be appreciated.

       

      Best,

      Devon