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 #98: SANTALYTICS 2017 - Part 2

martinding
パルサー

I struggled to get the layout right, had to check the community threads for help, credit to Philip Mannering!

スポイラ
98.png
grazitti_sapna
キャスター

Difficult Challenge. Required help for some of the elements.

Sapna Gupta
Kinga
アステロイド

hi,

 

Please find my solution. I need some help from community to solve it.

 

スポイラ
Kinga_0-1668354570343.png

 

JamesCharnley
パルサー
スポイラ
JamesCharnley_0-1669292826405.png

 

Ended up going to war with my Alteryx crashing over and over on this one and limitations working with the reporting cells. For some reason the crosstab tool would blow up if set to concatenate instead of first despite not actually applying the aggregation. Leaving it here so I won't be sworn off reporting tools but I'm still pretty happy with how the outcome.

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my workflow !

ahsanaali
ボリード
スポイラ
ahsanaali_1-1674653286281.png

 

 

スポイラ
ahsanaali_0-1674653255630.png

 

kristiadiuisan
アステロイド
スポイラ
Alteryx_challenge_98_KU.png
alacoume
アステロイド

My solution:

leonhekkert
アステロイド

My solution to challenge 98. Although I have to say the generate rows part is heavily inspired by the solution that I saw from @LordNeilLord

 

Was really struggling why i have extra space after the fourth column but saw in the end that the tool with rank 157 had name which was too long.. :|

 

スポイラ
Challenge 98.png
CeliaC_Silje
アステロイド

Workflow:

スポイラ
CeliaC_Silje_1-1679501609951.png

Period_Table.png