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
メテオロイド

Please tell me if this solution looks accurate

LordNeilLord
オーロラ
スポイラ
Weekly Challenge 8.png
KOBoyle
ボリード

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
アステロイド

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
アステロイド

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
メテオール

Thanks

sagarb
アステロイド

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

nick_ceneviva
ボリード

Solution Attached

ADerbak
ボリード

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

 

See attached.

DanielaMira
アトム

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