Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #8: Aggregate Consumer Purchases

samahmed28
6 - Meteoroid

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

nancylu
7 - Meteor

Here is my solution!

ReconBen
8 - Asteroid
Spoiler
Challenge 8.JPG

hayley9
8 - Asteroid
Spoiler
- Ch8_Solution_hr.yxmd.png
stan-bi
7 - Meteor

Here is my solution!

jacob_kahn
12 - Quasar

Fun challenge!

 

Spoiler
WORKFLOW.jpg

 

Garabujo7
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
ArtApa
Alteryx
Alteryx

The solution attached.

MDel
8 - Asteroid
 
DelHansen
8 - Asteroid
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