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
Alteryx Certified Partner

Went with my favourite multi-row formula as well

Spoiler
Screen Shot 2017-08-27 at 22.10.05.png

 

Highlighted
Alteryx Certified Partner

Hello forum,

 

My ranking solution varies quite a bit to the proposed solution; I have used fewer tools and no join or summarise. I prefer to work with formulae however a rank tool would have made life much easier!

 

Lucie

 

 

Highlighted
8 - Asteroid

I used two different approaches to creating the ranking system; the first way is the tile tool, and the second way is the multirow tool. Which one do you like best?

Highlighted
5 - Atom

I noticed many similar methods! I'm still getting used to the multi-row formula tool, but I eventually got it to work. :) 

 

Spoiler
Capture2.PNG

 

 

 

Highlighted
15 - Aurora
15 - Aurora
Spoiler
Capture.PNG
Highlighted
Alteryx Certified Partner

A similar solution to the answer compared to some of the other suggestions... Lots of options on this one!

Highlighted
Alteryx Certified Partner

I have to echo Sean Adams on this one! Same solution as @Rachel_Burge, but seems @mceleavey has the right idea with the tile tool. We live and learn...

Highlighted
8 - Asteroid

Rank got me a bit but solved it using multi-row tool. 

Highlighted
Alteryx Certified Partner
Spoiler
challenge9.PNG
Highlighted
6 - Meteoroid

My method was a little longer than the thread solution, but it works :)