Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #93: Pumpkin Production

M-Shedid
5 - Atom

Quick but not too Neat, and that took a lot of joins

estherb47
15 - Aurora
15 - Aurora

There is likely a more efficient way than this, but I'm playing catch up and need to get through several challenges. Rushing my result seems to mean a lot of tools.

Spoiler
image.png
vishalgupta
7 - Meteor
 
TimM
Alteryx Alumni (Retired)
Spoiler
image.png

 

nick_ceneviva
11 - Bolide

Solution attached

CynthiaE
Alteryx
Alteryx

Not as many joins (two) but lots of multi-row formulas! 

JefBus
7 - Meteor

 

 Got it, I think :)

i had to use 4 joins, just discovered the group by function on the sampling tool, thanks!

 

 

 

Spoiler
2017-11-11_1737.png2017-11-11_1740.png
maraquindoza
7 - Meteor

Attached is my solution! Would love to know how it can be done with lesser joins :)

_sbeaumaster
7 - Meteor
 
MaxGiegerich
8 - Asteroid

I think mine's simpler. But then I would I suppose... Pretty satisfying challenge though!