Challenge #8: Aggregate Consumer Purchases

[mshahid]

Challenge 8 Completed

[VladimirR]

Done.

[dzeyer]

my solution - interesting that the description in the forum differs from the one in the start file.

this gave me a hard time until I realized I need to change the date to July 1st 2013. Now I get the same result, even though my approach looks completely different and uses tons of tools.🙈

[JKPittman]

My first weekly challenge solution.

[stirsi]

Here's my solution. Thanks to Ben for guiding me through the solution as part of the onboarding process. 

[chandler-gjino]

Attaching my solution

changed description to be after July 2013 vs June 2013 as the solution was filtering after July

[fritz_mira]

Onboarding...

[joeoswald614]

Fun Challenge. Took a little planning to get the numbers.

Spoiler

1. Select Tool on PoS to make Date a Date, removed MemberID and Price
2. Filtered on Date >= 2013-07-01. <- Note, I initially interpreted since June as including June.
3. On True - One Summary for Count of Unique TicketIDs (Total). One join with Lookup Table on Desc
4. Filtered for Type = Side
4.a On False - Filtered for Type = Drink
4.b On False for Drink, Filtered for Type = Pizza OR Burger
5. On Trues for Sides and Drinks - Joined
6. On True for Pizza OR Burger - Joined with previous Join
7. Summary for Potential Meal Deal (count of TickeID)
8. Join the 2 Summaries
9. Formula to calculate % (Potential Meal Deal / Total * 100)

[ckoo22]

My solution!

[Chris_Green]

Here's my solution