4 Replies Latest reply on Dec 29, 2017 9:36 AM by Jassi Kul

    Bar Graph Percentage

    Jassi Kul

      Hi Friends, I am having trouble converting my Bar graph to display total %.

      Instead it is showing cumulative values.

       

      I would like to convert it to % instead of cumulative values.

       

      Desired result like below

       

       

      Thanks

       

       

       

      .

        • 1. Re: Bar Graph Percentage
          Jim Dehner

          Good morning

          Not sure I full understand the expectation but it this what you want?

           

           

          the formula is

           

          RUNNING_SUM([PIVOT_DISTINCT_COUNT]/window_sum([PIVOT_DISTINCT_COUNT]))

           

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Bar Graph Percentage
            Jassi Kul

            Thanks Jim,

             

            If you look at worksheet, Distinct Counts are cumulative where as what i am looking for is Non-Cumulative Bar graph representation in %.

             

            Thanks

            • 3. Re: Bar Graph Percentage
              Jim Dehner

              like this ?

               

               

               

              Jim

              If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

              • 4. Re: Bar Graph Percentage
                Jassi Kul

                I think i am not clear about what is creating problem. If you look at below graph,

                 

                My total distinct counts are 18,127.

                What i am getting below is cumulative values for each bar.

                 

                So technically my last bar shouldn't be 18,126. It should be 18126 - 404 = 17726.

                 

                Thanks