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.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.
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 #330: Check out the weather

Alteryx

Here is my solution. I was a bit confused by the dates mentioned in the question so I went with Mar-May = spring, Jun-Aug = Summer & Sep-Nov = fall.

Found I had to use two date-time options plus a text to columns to split up date and time. Keen to see how others did that in a more efficient way.

12 - Quasar

7 - Meteor

your range of the season is incorrect....look at my solution have got the same results.

7 - Meteor

your range of the season is incorrect....look at my solution have got the same results

7 - Meteor
• your range of the season is incorrect....look at my solution have got the same results

7 - Meteor
• your range of the season is incorrect....look at my solution have got the same results.

6 - Meteoroid

5 - Atom

Solved. also added a process to reconcile my calculated numbers with the target numbers. Noises due to inaccurate rounding. Enjoy!

7 - Meteor

Values are matching exactly

8 - Asteroid

All,

Spoiler

I'm glad that I wasn't the only one who was getting the different results.

-I'm sure that there is probably a better way,.

-I used 4 Text-to-Columns, a transpose and a cross-tab.

-Cheers!
Matt