Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Cloud Quests
Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.
Using my own datasource (which I had to deduplicate because it was hastily generated) I tackled this Quest #3!
Here's my take
Spoiler
the second aggregation step is to create te count per user, but as the tile tool inverses the rankings, I had to fix that using a max_tile + append + formula construction
the second aggregation step is to create te count per user, but as the tile tool inverses the rankings, I had to fix that using a max_tile + append + formula construction
My solution!!
I remember there was the similar challenge in Weekly Challenge. So I used Weekly Challenge #9's input file.
I attached my input file.
Thank you @AkimasaKajitani for providing a file! Solution attached:
Spoiler
Similar solution as well - is it just me or did the Tile tool not perform as expected?
Big thanks to @AkimasaKajitani for the example file! Here's a solution that uses Unique instead of Summarize:
My solution! loving the record id function with a sort integrated!
thank you @AkimasaKajitani for the dataset :)
