Challenge #8: Aggregate Consumer Purchases

[zpatel]

My Solution

[nguyentuan]

Similar solution

[Sivashankaran]

1. Join two data together based on common column "Desc"
   2.Filter the records from "2013 July 01"
2. Grouped Data by TicketID and aggregate count() data by price.
3. Then using this below Formula to set a Flag as 1 or 0 on Column "Potential Meal Deal" based on objective to filter out the records,

if (!IsEmpty([CountWithNulls_Pizza]) or
!IsEmpty([CountWithNulls_Burger]))
and
(!IsEmpty([CountWithNulls_Side])
AND
!IsEmpty([CountWithNulls_Drink]))
then
1
else
0
endif

5. Aggregate count and sum for "Potential Meal Deal" column
6. Use this formula [Sum_Potential Meal Deal] / [Count] * 100
   to figure out %

Thanks,
Siva

[NN]

First solution.

[Mikeimbi]

Challenge 8

[JWAJ]

This is one way of solving the challenge

[Yogesh_Kalantri]

 

[TheAnalyticalThinker]

First Challenge completed as part of Designer Onboarding process.

[james_western_HUN]

I interpreted "Since June" to include the period of June. Easy enough to change my date filter after seeing my final answer didn't match the output tab...

Spoiler

Join the data to add type; Filter by Date; Multiple filters for Condition A, then Join Condition B and C. Summarize the filter results and finally Join those result streams. Formula tool to create the final %.