Challenge #330: Check out the weather

[seanrobertson22]

Here is my solution! Was going to try to transpose tool but realized a join was easier to get the desired solution.

[myastarling]

here's my solution!

[AronasZilys]

Spoiler

[BS_THE_ANALYST]

Numbers not matching up for the average columns across all rows. There's an assumption I've missed somewhere. I'm not sure if it's how I've constructed my seasons. They seem to check out to me.. 🕵️. 

Spoiler

Time Taken: 23:00
Logic for seasons

 
workflow 

[Jonathon-Sheppard]

Spoiler

Spoiler

Thankfully, I seem to have the same data as the solution file. I just had to look at what the dates of the season changes were for that year (2012), and applied the correct end date to the 'fall' season.