Calculating Percentage on a Bar Chart

[#1]

Hi!

I'm new user and am building a horizontal bar chart that I would like to show the total number of awards for each award category and the percentage of total awards for each category as a label.  The Category Field is my dimension.

I was honing in the Category field to perform the calculations, but I can't get the percentage to calculate correctly.

I was hoping for some suggestions in calculating the percentage of awards for each category using the attached sample data.

Any help is appreciated!

Thanks!

Pat

[ahaahaaha · Accepted solution]

Hi Patrick,

May be like this

Dimension: Category,

Expression: Count(Category)/Count(TOTAL Category)

and on the tab "Number" of chart set the readings in percent.

Regards,

Andrey

[prieper]

Create another expression with text on Axis and an expression like

COUNT(Award) / COUNT(TOTAL Award)

Which counts the number of awards, subject to Dimensions shown in relation to the total count

Peter

[#4]

Andrey and Peter -

Thanks so much for your assistance and quick reply!  Your advice worked like a charm!

Much appreciated!

Pat

[abdul_mo]

thanks alot Andery