Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASo - I went about this happily one way, without looking at the recommended solution file, and came up with my 1st solution (attached). It gave me the same results, but I wasn't happy that the dates ranges still needed to be input manually, and that I wasn't using the provided test input file with the date ranges.
So I had a glance at the recommended solution and thought I'd go about building a 2nd workflow that eliminated any need for manually inputting date ranges. This feels better because it a) means I was utilising the data given and b) improving the repeatability of the workflow by eliminating any need for manual changes (e.g. if someone changed the date ranges in an input file).
I've attached both here.
That was a fun one.