Challenge #9: Analytics Ranking
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Rob-Silk
8 - Asteroid
12-02-2023
01:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
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.
sknman92
8 - Asteroid
12-04-2023
12:04 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
B_SarkadiNagy
6 - Meteoroid
12-06-2023
05:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
nSpire
9 - Comet
12-09-2023
06:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
pmag
8 - Asteroid
12-11-2023
01:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
caitlynmcintyre
9 - Comet
12-13-2023
09:36 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Shoujain
7 - Meteor
12-14-2023
07:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Aratryn
7 - Meteor
12-15-2023
02:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
phillipcjang
8 - Asteroid
12-26-2023
01:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
SanjeevDosanjh
7 - Meteor
01-03-2024
03:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator