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
bhrmitra
10 - Fireball
06-04-2020
03:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
abowers004
7 - Meteor
06-04-2020
01:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
cmv
7 - Meteor
06-04-2020
03:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Vikash_kumar
8 - Asteroid
06-04-2020
09:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx
06-05-2020
12:20 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great exercise to practice the different methods available to achieve a desired outcome.
Spoiler
Workflow
Florian Carrier
Strategic Solution Consultant
Alteryx
Strategic Solution Consultant
Alteryx
Tylercram
6 - Meteoroid
06-07-2020
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Attached is my workflow and output for Challenge #9
Spoiler
Process:
1. Renamed the value column and converted it to double.
2. Sorted the file by the descending order of the score
3. Used a multi-row formula with a conditional value to assign a rank based on the Score value.
4. Used a filter to limit the output to only the top 5 rankings
1. Renamed the value column and converted it to double.
2. Sorted the file by the descending order of the score
3. Used a multi-row formula with a conditional value to assign a rank based on the Score value.
4. Used a filter to limit the output to only the top 5 rankings
wincenzo
7 - Meteor
06-08-2020
10:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
AliAS2020
8 - Asteroid
06-08-2020
11:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi there,
Attached is my solution to the challenge.
Spoiler
Utilized Multi-Row formula and filter tools to achieve the expected results.
Happy learning.
AliAS
Skrupczak
7 - Meteor
06-09-2020
05:23 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Alteryx
06-09-2020
04:06 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It seems odd to me that a player could be beaten by 9 players and still finish 5th, so I solved it in two ways.