Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #9: Analytics Ranking

Highlighted
9 - Comet

My solution is attached. It was super easy.

 

Spoiler
WorkflowWorkflow

Thanks,

Abhra

7 - Meteor

This challenge seemed so simple at first, but once I started it became clear I needed more tools than I thought I would. The worst part was you could literally see the top 5 but figuring out how to show them correctly was a challenge.

Highlighted
7 - Meteor
Spoiler
cmv_0-1591310809417.png

 

Highlighted
8 - Asteroid

solution attached

Highlighted
Alteryx
Alteryx

Great exercise to practice the different methods available to achieve a desired outcome.

 

Spoiler
WorkflowWorkflow
Florian Carrier
Solutions Engineer
Alteryx
Highlighted
6 - Meteoroid

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
Highlighted
7 - Meteor
Spoiler
wincenzo_0-1591639148060.png

 

Highlighted
8 - Asteroid

Hi there,

 

Attached is my solution to the challenge.

 

Spoiler
AliAS2020_0-1591641828256.png


Utilized Multi-Row formula and filter tools to achieve the expected results.

Happy learning.

 

AliAS

Highlighted
7 - Meteor

Practice is helping me get so much better at using the multi-row field tool

Highlighted
Alteryx
Alteryx

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.

 

Spoiler
Challenge009.png