I am wanting to create a tree map, but only show the top 20 stakeholder groups based on the number of tickets they have associated with them, how would I go about doing that.
19 answers
Mike Pratt I made this on purpose because what is doing is accounting for the "ties".
The index shows up until the top 20 by row. However, if we filter just up until the 20th result we would be excluding stakeholders with the same values. Therefore, what we are doing is keeping everything that is under the 20th RANK. So if in one month every stakeholder has a different value of COUNTD(# Open Tickets), then the result would be 20 stakeholders exact. Does this make sense?
Best,
Diego
