community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #93: Pumpkin Production

Atom

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

Magnetar
Magnetar

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
Meteor
 
Alteryx
Alteryx
Spoiler
image.png

 

Highlighted
Alteryx Certified Partner

Solution attached

Alteryx
Alteryx

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

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

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

 
Alteryx Certified Partner

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