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

ganeshnaicker
7 - Meteor

Hi All,

 

My solution is different from the solution provided and it takes few steps than the solution

Falk
5 - Atom

Challenge9.PNG

 

ryan_b
6 - Meteoroid

Just completed my first challenge.

arein0
8 - Asteroid
 
Kdpalmer
8 - Asteroid

Alteryx PoW 9.PNGCan anyone explain the following: when I add a multi row formula for a rank column and group by "count" it always starts from the lowest count number, even when I  put a sort tool to have count in descending order (i.e. I was attempting to have "17" be at the top of the data set, and all names with 17 to be ranked "1" but could not achieve this with simply grouping by count and trying to sort by descending)? Thanks!

goncalopereira
6 - Meteoroid

My Solution.

mjholland
7 - Meteor

I tried to add in a rank column without splitting the input in 2 directions, which I struggled with. Splitting them was much easier, who knew?!

 

Spoiler
Challenge #9 Workflow Solution.PNG
AlexWHW
7 - Meteor

Easier than #8... hmmm 

Spoiler
AChallenge9.PNG
lainecaruzca
8 - Asteroid
Spoiler
SpolierChallenge 9 snippet.PNG
NilsM
8 - Asteroid

check out my solution:

Spoiler
 solution9.PNG