Forum Discussion
Solved
Finding top 5s of multiple actors
Hello there everyone, so I've joined some date sets/tables and am almost done with my assignment, I "only" need to determine the top 5 categories of the 5 actors who play the most roles. The latt...
If to imitate on such model
first you group by actor_id without aggregation
next sort each Data table by Qty (simplest by adding another column)
and keep Top5 in resulting table
Remove intermediate columns and expand latest one
If to imitate on such model
first you group by actor_id without aggregation
next sort each Data table by Qty (simplest by adding another column)
and keep Top5 in resulting table
Remove intermediate columns and expand latest one
.png){kind=link}
I have no idea how you came up with this.
But it worked perfectly! Thank you so much!
And the excel file helped alot
Mmrtlm , you are welcome.
In general you may combine all transformations of grouped tables in one function instead of adding new columns for each transform, but that's cosmetic.