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 #144: Secret Santa Assignments (BAH HUMBUG!)

Kakuffo
Alteryx
Alteryx
 
apabonok
8 - Asteroid

Hi. This is my solution.
I learnt about <Join by record position>

 

challenge_144_apabonok_spoiler.png

nivi_s
8 - Asteroid

Solved!

 

Spoiler
nivi_s_0-1577496509773.png
Hjardine
8 - Asteroid
Spoiler
Hjardine_0-1577595563953.png

Sorted ascending by scrooginess, used a count records tool to rank each, sorted descending and then used a count records tool to rank each in reverse, filtered for top 25 and bottom 25 joined both on record id, formula tool to calculate net scrooginess. 

myouree
8 - Asteroid

My solution.

Aswin
8 - Asteroid

My solution:

rmassambane
10 - Fireball
 
jfone
8 - Asteroid
 
joshuaburkhow
ACE Emeritus
ACE Emeritus
 
Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
paulburrows
8 - Asteroid

Keeping the xmas dream alive!!