This content has been marked as final. Show 7 replies
Hi, I am having issues using pie charts.
The data I have is, I have a set of rooms.
I have a list of people who have access to each of these rooms.
I want to count how many rooms there are with less than 10 people with access to these rooms.
I want the pie chart to show what fraction of the rooms have less than 10 users with access.
I have tried:
=if(count(Distinct(aggr([Room], [User])))<=10, count(distinct([Room])))
this gives me the total count of the rooms rather than only those with 10 users or less.
I have been stuck on this for awhile. Any help is greatly appreciated.