community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
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.

Challenge #93: Pumpkin Production

Asteroid

My solution:

Asteroid
Spoiler
image.png
Asteroid

2019-01-25.png

Asteroid

My solution

Asteroid

My solution

Spoiler
93.png

 

Highlighted
Asteroid

my solution(compact with less no. of tools):

Alteryx Certified Partner
 
Asteroid

hmm used loads of joins

 

Summary tool to get total by state and year, summary tool to get min and max for year and then summary tool for state & average. Muliple joining to get all the columns and then a summary tool to calculate Min/Max Average Diff. Finished off with final summary tool to group by all required columns

Meteor

It was a nice challenge. Thanks!

Spoiler
challenge_93_Pumpkin-Production.png
Asteroid

Who knew so much about pumpkins? All I know is they make a great pie!

Spoiler
Challenge 93.PNG