Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community!
I'm trying to build a stacked bar chart that shows the count of the ranking divided by the total count of rankings for a distinct time period. My data is similar to the below. I have a stacked bar chart with time and ranking as dimensions, but i'm struggling to get the measure right. Ideally I would have 3 bars totally to 100% each and the ABC's for each time bar would add up to the 100%.
Time | Ranking |
1 | A |
1 | A |
1 | B |
1 | C |
1 | C |
2 | A |
2 | B |
2 | B |
2 | B |
2 | C |
2 | C |
2 | A |
3 | A |
3 | A |
3 | A |
3 | A |
3 | B |
3 | A |
3 | A |
3 | C |
3 | B |
Any help would be greatly appreciated.
May be this
Dimension
Time
Ranking
Expression
Count(Ranking)/Count(TOTAL <Time> Ranking)
May be this
Dimension
Time
Ranking
Expression
Count(Ranking)/Count(TOTAL <Time> Ranking)