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
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #8: Aggregate Consumer Purchases

Highlighted
6 - Meteoroid

Just starting out with the weekly challenges, this was still tricky though. 

Highlighted
7 - Meteor

Here is my solution!

Highlighted
8 - Asteroid
Spoiler
Challenge 8.JPG

Highlighted
8 - Asteroid
Spoiler
- Ch8_Solution_hr.yxmd.png
Highlighted
7 - Meteor

Here is my solution!

Highlighted
12 - Quasar

Fun challenge!

 

Spoiler
WORKFLOW.jpg

 

Highlighted
Alteryx
Alteryx

All set, this one was not so difficult but a little tricky because the challenge's description is different from the one in the workflow and the one in the page, with the one from the workflow I couldn't get the right answer, but with the one in the page I could.

The error is in the date, in the workflow states that the date is June 2013 and the correct one is from the page, July 2013.

 

My solution here:

Spoiler
Solution challenge 8.png
Highlighted
Alteryx
Alteryx

The solution attached.

Highlighted
8 - Asteroid
 
Highlighted
7 - Meteor
Spoiler
Took a while to realized that phrasing of June v. July in the summary was creating my issue. Similar approach to others
 - Joining based upon description
 - date field conversion and filtering
 - summarizing data
 - splitting all tickets for the total
 - identifying combos
 - maths

DelHansen_0-1582427121102.png