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

Here's my solution.

Perfect example of a use-case for the ...

Multi-Row Formula Tool!

Solution Attached

Here is my solution to this challenge!

Challenge 9 Done.

Workflow

Thanks & Regards,
Allwyn Thomas

Basically, sort descending , add a record id and then a multirow formula to check if the count is less than the previous count then increment the rank by 1 otherwise keep the row-1 rank. The first row id had been assigned a rank of 1. Then once all is done filter for all ranks less than or equal to 5. Solution has 12 rows

Weekly Challenge 9 Solved.jpg

Solution attached.

Here is my submission.

curated machine learning resources