Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #8: Aggregate Consumer Purchases

raj_k
Météoroïde

Please tell me if this solution looks accurate

LordNeilLord
Aurore
Révélation
Weekly Challenge 8.png
KOBoyle
Bolide

Solution attached.  Since the string values for the Date sorted chronologically, I did not bother parsing.  I didn't think to branch the logic to calculate the total tickets separately from the potential meal deals.  That approach seems unnecessary.

 

Ken

A_Twa
Astéroïde

My approach was very similar to others (and different from the posted solution) - looking at the solution file gives me additional ideas for consolidation/optimization of processes going forward.  Thanks!

MsBindy
Astéroïde

I thought I was using an awful lot of tools to get to the answer.  Glad to see that my solution is in the ballpark :)

robcarroll
Météore

Thanks

sagarb
Astéroïde

Used two new tools in here, Append Fields and Count Records.

nick_ceneviva
Bolide

Solution Attached

ADerbak
Bolide

I probably did way too many tools, but I got the solution!

 

See attached.

DanielaMira
Atome

Hi, this is my first challenge, I tried to keep the workflow as simple as possible