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.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #9: Analytics Ranking

Frachiu
7 - Meteor

I could not resolve how to rank the duplicates so I had to look at the solution and copy it.

Multi row formula wont help as I don't understand the expressions.

I tried tile but couldn't figure it out.

 

I could have represented the final result by using select records or sample but that is not the point.

 

 

 

GemmaM
7 - Meteor

Nice to get some more practice on Multi-row formulas.

AlexvanOs
8 - Asteroid

My solution.

Spoiler
Gotta love the tile tool! 
Challenge 9 solution.png

hs0egr
7 - Meteor

.

LiuZhang
8 - Asteroid
Spoiler
9.png
ainderike
7 - Meteor

My solution is attached.

drexelchin
Alteryx
Alteryx

My solution

alishadhillon__
7 - Meteor

Never used the tile tool before so gave that a go in the process!

 

Screenshot (43).png

 

Adrian_T
Alteryx
Alteryx

My solution!

Spoiler
Adrian_T_0-1635140280137.png
OlehNikitenko
7 - Meteor

My solution