How can we help?

New post
0

Percentage of total

Avatar
Joost Glaser
None
Follow

Hi, 

I want my Klip to show for each category on the X-Axis the percentage of that category against the total of the values. 

Now I see for example that the category 0 is 40 % of the total. However this is the count (40). How can I make sure that it shows not the count but the percentage of the total.

 

 

 

 

Date Votes

3 comments

  • 0
    Avatar
    Janice Janczyn

    Hi Joost,

    Thank you for posting to our community! Your formula will have to calculate the percentage. For example, if your formula is currently pointing to column A,

         NPS series: @A:A

    change it to

        NPS series: @A:A / SUM( @A:A ) * 100

     

    Happy dashboarding!

    Janice

  • 0
    Avatar
    Kien Nguyen

    hi,

     

    i get this problem.

    it is not showed percentage by catagory on X Axis

     

    Can you please share this ?

     

  • 0
    Avatar
    Janice Janczyn

    Hi Kien,

    Please provide more details about the issue you're seeing. What your formulas look like and what the klip is currently displaying.

    Thank you,
                  Janice

Please sign in to leave a comment.