Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Not entirely sure, but does this help
=Aggr(NODISTINCT Count(DISTINCT {$*BM01} [person_id]), year)
Not entirely sure, but does this help
=Aggr(NODISTINCT Count(DISTINCT {$*BM01} [person_id]), year)