Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have this stacked bar chart that i am trying to convert into 100% bar chart and having difficulties pulling up count by total for this.
Dimensions:
Stack: Team
Bar: =IF(NOT MATCH(State,'Closed','Resolved'),State)
Measure:
Count({<Aging=>}Number) //This is taking the count ignoring the filter at Sheet level & Works fine for regular stack bar graph
But when i try to change this for 100% Bar graph, my bars are shown with 0 & 1 instead of actual %
Count({<Aging=>}Number)/Count({<Aging=>}Total <Team> Number)
Appreciate the guidance here.
On your measure on the chart, make sure the number formatting is set to number then in the dropdown make sure you select one of the percentage options.
On your measure on the chart, make sure the number formatting is set to number then in the dropdown make sure you select one of the percentage options.
That did the trick .. Thank you @Nicole-Smith