We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

Challenge #9: Analytics Ranking

Rob-Silk
8 - Asteroid

My solution below - an initial attempt followed by realising there is a much easier and simpler solution after that:

Spoiler
Initial solution used a ranked list of unique counts joined back to the original data set and filtered for top 5;
then realised that the same thing could be achieved by simply sorting the data set, using the mighty multi-row formula tool to set the ranking and then filtering for top 5.
challenge_9_RS_screencap.PNG
sknman92
8 - Asteroid

solution attached

B_SarkadiNagy
6 - Meteoroid
Spoiler
2023-12-06_14h27_40.png
nSpire
8 - Asteroid
Spoiler
009.png
pmag
8 - Asteroid
Spoiler
Screenshot 2023-12-10 161630.png
caitlynmcintyre
9 - Comet

easy peasy!

 

Spoiler
9.png
Shoujain
6 - Meteoroid

Here is my solution.

 

Aratryn
7 - Meteor

Solution

phillipcjang
7 - Meteor
Spoiler
challenge_9.png

SanjeevDosanjh
7 - Meteor
Spoiler
Screenshot 2024-01-03 110156.png