Challenge #8: Aggregate Consumer Purchases

[bnelly1987]

Thanks!

Spoiler

[smatthies]

Solution attached. Date was tricky to get just the right count of records.

[viveknshah]

Spoiler

[PraveenSoori]

Solved using both Join & Find/Replace

[salankayana]

1. Find & Replace the Type based on the Desc
2. Remove Duplicates based on Ticket ID and Type
3. Cast Date to DateTime and filter on required Dates
4. Summarise at Ticket ID level and Concatenate the Type into one column
5. Flag as "Deal" if the concatenated column has a combination of Burger, Side, Drink or Pizza, Side, Drink; else tag as "No Deal"
6. Count "Deals" and find the percentage of total.

Regards,

Salankayana

[Hitch]

Here's my attempt, certainly not the simplest solution!

[lavanyadurai]

Spoiler

[Vidya26]

My Solution

[mcultrera]

My method used mostly filters/joins in lieu of the flag/summarizing method shown in the solution. 

I see the wording on the web was updated to July from June, but I was using the instructions in the start file, so it took me a while to figure out that I was using a different date.  I guess I was using the old file?

Cheers!

[kelsey_kincaid]

I got hung up on the date ranges, but got there eventually. Thanks for another good challenge!

Spoiler