Challenge #8: Aggregate Consumer Purchases

[jjrbondoc]

Spoiler

[DanTh]

Nice Join challenge, took one off my score as I think I took too long with it.

4/5

[dbmurray]

Found the wording of the question somewhat confusing, but managed to get it in the end. 

[cwkoops]

A lot of filters, similar to others I bet. 

[Elias_Nordlinder]

Fun challenge.

Took longer than I thought, but find some nice tools.

Spoiler

[Jishnu_K]

Using traditional join tools!

[sbarton]

challenge 8 solution.

[aravind_sk]

Spoiler

[pdave87]

Brilliant Learning, PFA my solution 🙂

Thanks for this assignment.

Regards,

Pratik

[NicoleDuhamel]

Solution attached!

Hint - identify which orders have a side & drink independently of whether the order has a pizza or burger so you can get the right number of tickets.

I took a slightly different approach, used a Summarize tool to group by ticket number & concatenate the types, then used a couple of Contains formulas to identify a) tickets containing Pizza or Burger and b) tickets containing Side & Drink. Then another formula to combine the results of those two, giving four possible combinations between Pizza/Burger/other with or without a Side & Drink. Then it was just a case of totalling up the number of tickets & calculating the percentage.