In the attached sample workbook I want to display a type of a small multiples treemap visualization where nested categories within each treemap multiple add up to 100% of that particular Region/Category combination. Since they are all 100%, I expect all treemaps to be of the same size. However, that's not the case. What am I doing wrong?
@Dmitry B
Well, you are not doing anything wrong, but it has to do, with the count distinct. An example:
Let's suppose you have an order in two products A, B. When you compute COUNTD(ORDER)/TOTAL(COUNTD(ORDER)) for product A you are getting 100%, and for product B 100%, and the total size of your bar would be 200%, because each of these adds to 1.
So, as a workaround, if you want all your tree maps the same size, is to use:
[Measure] / WINDOW_SUM([Measure])
Edit the table calculation Compute using product name and segment.
Attached you will find the twbx.
If this post resolves the question "Select as Best" or if it assists in resolving the question, please "Upvote". This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego
