I have a stacked bar chart where the columns are split by a calculated dimension. What I want to have is a stacked barchart with all bars showing the percentages (i.e. summing to 1)
DIMENSIONS
Dim 1 year
Dim 2 =aggr({$*BM01} count(distinct [case_id]), [person_id], [year] )
EXPRESSIONS
No of unique persons
=count(distinct {$*BM01} [person_id])
Total for each year
=count( total <[year]> distinct {$*BM01} [person_id])
However, the two expressions just gives me the same numbers, and I have also tried with the <person id> after the total. Any other suggestions for how to achieve what I wanted?
So far, the best solution I have tried is a Mekko-chart, however, I am still not able to find out how to get labels with dim 2's share of each column.
Moving the calculation to the script is not an option.
