Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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
Great problem to stretch the core muscles and play with some transformation tools.
Spoiler
Wasn't particularly detailed in my solution documentation this week but essentially filtered our everything but the beginning and end time periods, pivoted the data, calculated growth, sorted, selected the top for each type/PLU, and the latter part was formatting data to the final (took liberty with names).
Wasn't particularly detailed in my solution documentation this week but essentially filtered our everything but the beginning and end time periods, pivoted the data, calculated growth, sorted, selected the top for each type/PLU, and the latter part was formatting data to the final (took liberty with names).
First solution submission. I have included a Quick and Dirty flow to provide the information exactly as requested and a more Dynamic flow which will automatically calculate if more PLUs are inserted into the data.
Spoiler
I didn't format the next one the same way and kept it in the Tidy format. It uses a batch macro to be more dynamic and adjust if more PLUs are inserted. If 100 PLUs are inserted, you don't want you table growing that wide.
