Challenge #8: Aggregate Consumer Purchases

[Data_User88]

Here is my solution - 

[Will_Condon]

Similar approach to the solution used.

[fimler]

My solution.

[david14]

My solution is similar to others. The key thing I did was summarizing the data after the join operation with grouping by TicketID and Type and counting each type. I then created a crosstab (keeping the group by TicketID) and summing each type (it doesn't change any of the data) to create a single row for each TicketID. Using the logic in problem, I used a conditional formula that checked if the critical meal types were greater than 0 in count. If criteria met, 1, else 0. Then all that was left was summarizing to get the potential meal deals and total, followed by formula tool to calculate percentage.

I was unsure at first if nulls would create errors in the conditional formula. I split this part in two at first to see if there would be a difference between leaving nulls or using a multi-field formula to replace nulls with zero. Both methods matched results with target.

[gregchristensen]

Spoiler

[Haris_Hasan]

Spoiler

[rahofnouse]

Slightly different approach

[rogshih]

Spoiler

I got tripped up by trying to use FindString instead of Contains in the first Formula. For some reason, it returned all TRUE for the expression.

[DataHabanero]

Delivering my solution, I think the time range definition in the excercise description is definitely misleading, but the comments helped me get through.

[MKteryx]

Challenge 8 completed