Challenge #8: Aggregate Consumer Purchases

[Ladarthure]

My solution

[nakamott]

Null filter could have been one step but this way is less thinking!

[cgoodman3]

Here's my solution

Spoiler

b

[chpoland]

Spoiler

[Jean-Balteryx]

Here is my solution ! Really interesting challenge !

[JWS]

Very interesting one!

[schenkelpat]

Thanks for the challenge!  I solved it in a different way than the proposed solution.  New to alteryx. Love that there are multiple ways to solve a single problem.  That being said, i know there are efficiencies gained by doing things certain ways.  Are the solutions posted by the OP optimized to be most efficient?  I would love to understand the efficiency gains of doing it one way versus the other!

Cheers,
Pat

[dvsrtns]

Good challenge!

Spoiler

[ctrl_kudorje]

1) The since June 2013 comment did throw my output off, but adjusted the date filter for >='2013-07-01'

2) I used classifiers to identify the end values needed for the count and percentage of total.

3) Originally I was thinking of tickets that actually had more than one Meal deal. For this piece, I attempted to work on it and put it for now inside a deactivated container and proceeded to get the answer for the challenge's requirement. I am happy to hear from anyone to see how we can get a true count of all Meal deals irrespective of the ticket id.

Spoiler