Challenge #8: Aggregate Consumer Purchases

[Xlblaze]

I feel like I went around the house a bit here, but got there.

Spoiler

Join to the lookup table
Ensure the Date field is a data, filter on the date
Concat each ticket to the groups.
Check the con field contains Pizza/Burger
Check the con field contains Side and Drink
Check the above are both Ture
Groupby and Count, reanarge and calculate

[nravik]

Solution attached, thanks.

[ClarKyle]

Solution found! Getting quicker at this stuff.

[JA]

My solution

Spoiler

[AngelosPachis]

My solution for Challenge #8. I didn't use the flag method suggested in the solution, although that was very smart thing to do. I used a summarize tool and concatenate instead, and then a multiple "contains" statement

[djodts]

Here's my solution

[cstroh]

Spoiler

My flow is a little more complicated than it probably should have been. Looking back, I could have created one filter with (type = pizza or type =burger) and type = drink and type = side, but this got the job done.

[getintodata]

Here is my solution!

[jdbartosh]

uploaded