Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
I am not sure that this is the right place to answer the weekly challenge
My approach is
1. rank by asscending by "Rating"
2. and give the number by grouping the "Class Name" through the Multi_Row Formula
3. and Filter only the Five highest from each "Class Name"
Must try to condense as the model answers
Thank you for reading
Thank you for reading
Fun challenge!!
Spoiler
Decided to deal first with the discrepancy in the data by using only the first instance of item 1119. My first solution (topmost in the flow) looks like many others.
But, I noticed that some ratings were tied, and the ones that made it into the final result were simply the first from the list. Second solution lets all tied results in as the top 5, so there are many more answers at the end. Did this with a Tile tool, set to Unique Values, with Unique Value being the average rating, grouped on department and class. Then a filter for where that tile number is <=5
But, I noticed that some ratings were tied, and the ones that made it into the final result were simply the first from the list. Second solution lets all tied results in as the top 5, so there are many more answers at the end. Did this with a Tile tool, set to Unique Values, with Unique Value being the average rating, grouped on department and class. Then a filter for where that tile number is <=5
This is my first Challenge response, but I kept hitting the #1119 issue. It was important to me to match the desired output exactly, so thanks to Verakso's approach, it gave me the insight I needed.
