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

bhrmitra
10 - Fireball

My solution is attached. It was super easy.

 

Spoiler
WorkflowWorkflow

Thanks,

Abhra

abowers004
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.

cmv
7 - Meteor
Spoiler
cmv_0-1591310809417.png

 

Vikash_kumar
8 - Asteroid

solution attached

FlorianC
Alteryx
Alteryx

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

 

Spoiler
WorkflowWorkflow
Florian Carrier
Strategic Solution Consultant
Alteryx
Tylercram
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
wincenzo
7 - Meteor
Spoiler
wincenzo_0-1591639148060.png

 

AliAS2020
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

Skrupczak
7 - Meteor

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

JeffF
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