Challenge #8: Aggregate Consumer Purchases

[Soura]

Based on my understanding the count of type should be distinct because 3 people can buy meal associated with a ticket and if the ticket has three distinct type food and further if those are only Drink, Burger/Pizza and Side then thats the count.

Attached

Please let me know if there is any issue

[AdrianFilip]

Please find the solution attached

Spoiler

Spoiler

@Community_Admin The exercise is a bit difficult to understand. It requests to run the calculations for "tickets since June 2013" (my understanding being 01.06.2013) whilst the solution is offered from tickets from 01.07.2013. I was checking my results and they were different, and after digging more into the solution I spotted the gap. It may be confusing for some, so maybe rephrasing it could help?

Thank you 

[aerxbb]

A pretty simple workflow using nested if statements to flag Meal Deals.

[Tberney]

Trickier than I expected. Had to give the unique tool a workout

[clintonang]

Great exercise! 

[AnnaMikhaylova]

My solution follows the text rather then provided output, as "since June 2013" in my world will start on 1st of June 2013 (Finance background, you need to be exact). I did test it on filter since 1st of July 2013, and it returned the same result as required task.

Spoiler

[treepruner]

It isn't elegant, but it gets the ouput

[Huy2508]

Here is my attempt

[JoePC]

Completed solution attached.

[Tony_Castillo]

Spoiler