Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!IDEAS WANTED
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit Feedback
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.
