Challenge #8: Aggregate Consumer Purchases

[SueDonim]

Spoiler

- Filter by date to capture tickets from 1 July 2013
- Upper portion to calculate total number of tickets in relevant time period
  -- Count unique ticket IDs
  -- Rename field
- Lower portion to calculate total number of meals that were possible meal deals
  -- join both tables
  -- change [price] to number (easier to work with than string)
  -- cross-tab on type and price for each ticket
  -- identify potential "meal deal" ((burger OR pizza) AND (drink AND side))
  -- filter for "meal deal" records
  -- count records
- Join total and meal deal counts
- Calculate %
 

Probably not an elegant solution, but it worked

[jarjarbingie]

Spoiler

[Yoyo_Master]

Interesting challenge

Spoiler

[JennyMartin]

Spoiler

Good challenge for beginners

[rmforcreamlisa]

Here is my solution.  

[jusdespommes]

From June confused me - but read the comments below and understood what you meant. Nice, thank you 🙂

Spoiler

[DuncanT]

Here's my solution.

[DuncanT]

oh, saw it was top 5 only. Fixed to do that (with my rank hack it was easy, I just joined with a text file with numbers 1-5 instead of 1-12)

[WilliamR]

Using a crosstab

Spoiler

[kmbutterfield]

FINALLY!!