Stacked Bar Chart Set Analysis

[eaphymaoweave]

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.

[sunny_talwar · Accepted solution]

May be this

Dimension

Time

Ranking

Expression

Count(Ranking)/Count(TOTAL <Time> Ranking)