Hello! I've been a little stuck on this for a while...
I have a huge dataset which looks at the number of streams a song makes each year from 2000-2022. I want to look at the "Top N" (maybe 30 or 50) each year.
e.g... (not real dataset)
However, I'm not looking for a "ranking", I want to make calculations using Top N group such as...
- What % of streams did the 'Top N' make out of all songs that year?
- What % of the Top N streams were 'Pop' each year?
I basically want to treat the 'Top N' as it's own group so I can do analyses within that group but also to look at the group relative to the whole dataset.
Is there a way to do this? Many thanks for your help :)
you can take a look at https://jimdehner.com/2021/10/04/sets-and-filters-the-condition-and-top-n-tabs-what-do-they-do/ it will show you different ways to do top N - suggest you start with an lod at the year / song level and go from there - when you have something to look at in the form of a tableau workbook please attach it here as a twbx
