23 Replies Latest reply: Apr 11, 2018 5:38 AM by youssef belloum RSS

    Percentage in  Stacked Bar Chart

    Vivek Anand

      I have a bar chart with

      1-Dimension

      3-Measure

      All the 3 measures have different filters applied to it

      When I am trying to find the percentage I'm not able to get 100%

      Sometimes I'm getting more than 100% , sometimes less than 100%

       

      As of now i'm using the formula for percentage is:-

       

      count(fields)/count(total fields)

       

      or

       

      sum(fields)/

      sum(total fields)