Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Andrey and Peter -
Thanks so much for your assistance and quick reply! Your advice worked like a charm!
Much appreciated!
Pat
thanks alot Andery