Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAProbably used a lot more tools than I needed, but was able to match the solution
Nice challenge.
Thank you
Decided to do part two in a way i wouldn't recommend as I decided I didn't want to use a filter for the date. Happy with how it works though 😄
This was one more case where I would have liked to have communication with the requestor in order to clarify what was meant by certain parts of the problem statement.
Also, as with most of data analysis it is useful to know whether or not the workflow needs to be reusable with different inputs. Mine would not work with other dates because I wrote it with hard-coded date filters. If I wanted this to be more reusable then I would change that.
Third, I left my final result clearly labelled but not identically named compared to the given answer. This is the spirit of the request. I could have made it the same layout and column names as the given answer if I were working with a real person who specifically requested that.