Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis is good one in that it tests out your ability to get the most out of the tools, as opposed to knowing which tools to use. As a beginner, it was relatively obvious which tools to use but putting them into practice effectively required me to develop a better understanding of alteryx syntax, particularly for the dates. Hopefully my solution can help others. Cheers.
Here is my take. After I finished, I realized you could probably do this with just one tool.
Getting better at Date and Time handling, but I suspect there was a more direct way to handle this
[EDIT: Duh! Don't know why I didn't use the DateTime tool]
My solution