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

michael_apau
8 - Asteroid

Screenshot 2023-03-15 164531.png

yuval
6 - Meteoroid

solution include python

Joel_F
6 - Meteoroid

The solution is based on the reference of 'since June 2013' within the start file.

hang_nguyen_kpmg
8 - Asteroid
Spoiler
hang_nguyen_kpmg_0-1679399256913.png

 

Lessons learned:

- Never hard-code rules in Formula tool. Use text input instead.

- Double check the condition details for Filter tool.

- Always use DateTimeParse() function to extract date. 

sylwia-rej
7 - Meteor
Spoiler
sylwiarej_0-1679415474950.png

 

ShaneCole
5 - Atom

Completed!

dshaugh
6 - Meteoroid

Completing Challenge 8 during Onboarding

Hammad_Rashid
11 - Bolide

Challege_8_Flow.png

Alex_Stoica
7 - Meteor

Challenge #8 - Solution

CanalB
8 - Asteroid

Hello. 

 

My solution.