How do I get percent of total on pie chart?

travorhouse · 2022-05-11T18:27:07+00:00

There was an error rendering this rich post.

How do I get the percent of total on a pie chart?

I added pie name and pie value, then change the pie value format to a percent. Rather than giving me a percent of a total, it is giving me the percent. For example, one of my numbers is 799. When I change the format to a percent, I get 79,900%.

What am I doing wrong?

Find more posts tagged with

Analyzer

Visualization

Cards

Accepted answers

All comments

GrantSmith

You need to tell it to display the percent of total. This can be done under Data Label Settings then using %_PERCENT_OF_TOTAL as the Text value.

pstrauss

@GrantSmith

Is it possible to use %_PERCENT_OF_TOTAL on a state map visualization? Otherwise how can I show percentages of total on that instead of counts?

pstrauss

FYI, this SEEMS to work but I wanted to validate that it is the right way to do it:

COUNT(DISTINCT(`Main Ticket ID`))/ COUNT(COUNT(DISTINCT(`Main Ticket ID`))) OVER ()

UPDATED: That doesn't work. Do I have to do windowing in my ETL to display a percent of total on a State chart? Seems kind of silly since you can do it on other chart types.

pstrauss

Ahhh… this appears to be the right way to do it.

COUNT(DISTINCT(`Main Ticket ID`)) / SUM(COUNT(DISTINCT(`Main Ticket ID`))) OVER ()