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

MalluShroomer
7 - Meteor

Took some time to figure out that the date to be filtered is from 2013-07-01 and not 2013-06-01. This should have been phrased correctly. The solution I have seems to be simpler and cleaner that the few I saw posted in the initial replied. 

 

Spoiler
MalluShroomer_0-1619860496041.png

 

maicolpolvere
6 - Meteoroid

Thank you for the Challenge! Very Interesting! Here my solution with some comments.

 

Maicol Polvere - Sprint Reply Srl

j_trefethen
8 - Asteroid
Spoiler
Alteryx Week 8 Challenge.png

ENix
8 - Asteroid
Spoiler

ENix_0-1620645373353.png

 

arpit_tyagi_crg
5 - Atom

@TomWelgemoed : I found your solution even better than the original one. That is actually more closer to the real world problems.

a big thums up to you.👍

TomWelgemoed
12 - Quasar

Hi @arpit_tyagi_crg ,

 

What a nice thing to say! Thank you - and good on you for looking at the various ways it could be done.

Thomas_B
Alteryx
Alteryx

Solution attached

Erin
9 - Comet
Spoiler
Count versus Count Distinct tripped me up for a little while on this one. Great challenge, thank you! Submission attached. 

Challenge 8.PNG
joelmiller66
9 - Comet
Spoiler
Challenge 8 Image.png
Ridler
5 - Atom

Fun challenge :0)

 

Spoiler
Ridler_0-1621345781667.png