Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Cloud Quests
Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.
Second one in the books.
I think it's unfair doing these challenges while being distracted by @joshuaburkhow 's face on the first page.
Spoiler
So, I brought the files in and joined them together, keeping the Point of Sale dataset as primary. I then ensured the Date field was assigned the correct data format, then filtered to only show those orders since 2013-07-01. I then counted the total orders along one stream, and on another stream filtered it down to the orders that contained Pizza or Burger and had a side and a drink. Appended these to values together and calculated the percentage of the total orders. Simple.
So, I brought the files in and joined them together, keeping the Point of Sale dataset as primary. I then ensured the Date field was assigned the correct data format, then filtered to only show those orders since 2013-07-01. I then counted the total orders along one stream, and on another stream filtered it down to the orders that contained Pizza or Burger and had a side and a drink. Appended these to values together and calculated the percentage of the total orders. Simple.
