Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEALevel: Easy (Prep/Join/Transform tool categories)
Time: 15 minutes
Tip: I found it easiest to break it down to 4 tasks:
1. Filter trans. data since June 2013
2. Get type info per transactions
3. Determine if meal deal criteria is met
4. Calculate totals and percentages
Here's a snapshot of my solution - to see full solution download attached .yxzp
I did solve this in the end.
But it had me confused that the challenge said "tickets since June 2013", if only had read the text on post where it says "orders since July 1, 2013".
Once I used that date, my result matched the output provided
//Thomas
use Group concatenate to filter the data
use Group concatenate to filter the data