Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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