We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
alteryx Community

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

## Challenge #93: Pumpkin Production

8 - Asteroid

this one was a little harder then the usual ones categorized as 'Beginner'. But it was also fun - I learned a lot!

Spoiler

7 - Meteor

Admin/Moderator, requires your attention here please..!!

Solution uploaded as per desired result set.

However, IMO, "Min Average State Production" should be computed as the average of the 'minimum' production per state like its computed for  "Max Average State Production".

However in the former, its computed as the overall average of the production per state. So the column value doesn't matches with the column header title in actual sense...!! (marked in the image)

Anyways solution provided to get the desired results.

Spoiler

8 - Asteroid

At first, I thought my solution was unnecessarily long, but it seems that everyone used a lot of joins to make this work. Maybe the challenge should have included, make it work with the least amount of joins as possible.

7 - Meteor

Challenging but fun. Feels like I'm getting more comfortable in using the Dynamic Rename, but a challenge that even with this answer made me wonder about having fewer Joins and/or fewer tools. I do find the solution posted at the top intriguing as well as others here. Good stuff!

9 - Comet

My solution

Spoiler

7 - Meteor

This is my solution!

8 - Asteroid

Challenge #93 solution

8 - Asteroid

I enjoin you to see my solution!

Spoiler

8 - Asteroid

Solution Attached (Hopefully, any feedback welcomed)

p.s I now detest pumpkins!

8 - Asteroid

My solution for this challenge.