Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
alteryx Community

# Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

## Challenge #392: Calculate Climate Extremes

Alteryx

Hi Maveryx,

A solution to last week’s challenge can be found here.

As a part of our Weekly Challenge User Group October Takeover event, we selected an exciting challenge we received from @myastarling, a member of the Milwaukee User Group. Thanks, Mya, for this fantastic contribution!

You have been tasked with creating a table of average temperatures by region and determining the locations of the warmest and coldest monthly and annual temperatures in the US. Luckily, you remember that the National Oceanic and Atmospheric Administration (NOAA) tracks climactic data through weather observing stations in the 50 US states and US territories, and the National Centers for Environmental Information provides access to the data.

In addition to a variety of other climate measurements, NOAA tracks average temperature. You get the OK to report temperatures by weather station. Using a dataset that contains the normal mean daily temperatures between 1981 and 2010, your challenge is to provide the following:

1. The station with the warmest average annual temperature
2. The station with the warmest average monthly temperature, and the month it occurs
3. The station with the coldest average annual temperature
4. The station with the coldest average monthly temperature, and the month it occurs
5. A table of all stations and their average temperature by month

9 - Comet

My solution for the weather challenge!

Spoiler
9 - Comet

My Solution:

Spoiler

12 - Quasar

Nice Challenge

Spoiler
11 - Bolide

C392

Spoiler
Workflow has output table in it, screenshot missed it
17 - Castor

My solution!

Spoiler

11 - Bolide

Solution attached

Spoiler

Spoiler
Solution using Control Container. Average temperature by States.

16 - Nebula

Solution attached..

Spoiler
20 - Arcturus
Spoiler
16 - Nebula
Spoiler