Challenge #8: Aggregate Consumer Purchases

[BenFr]

Great exercise to learn more about handling null values

スポイラ

[JoaoLeiteV]

The question was a little ambiguous, only by checking the expected output I found out that I had to start on 07/01, not 06/01.

スポイラ

[Rebecca_Neville]

Good one 🙂 

[minam]

My first attempt had an interesting error. Took some time to troubleshoot with the second solution.

Method 1 does not work because the sum of the tag values Pizza/Burger + Side+ Drink may be greater than 3 if three pizzas are ordered without a side or drink (which does not qualify as a meal).

Attaching both attempted workflows- maybe someone would find it useful!

[DSinnett]

My solution.  A fun challenge.

[dfurlow]

my approach was to filter out irrelevant records, then used cascaded joins to arrive at all tickets with the 3 types required, which produced some duplicate records, so used Unique to pare down.

[duartepimentel]

Solution attached

[Caesar]

Not the cleanest solution, but get's the work done.

[VizChic]

FG Solution on Alteryx Adventure 

[kcfuiks]

Solution attached. Yay for formulas!