This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
A solution to last week’s challenge can be found here.
This week is part 1 of the challenge “Blowing in the wind”.
On December 30, 2021, a windstorm moved through some of the Front Range counties of Colorado. One Alteryx associate found herself driving back home in the storm and being “blown in the wind”. And she got the idea for a two parts challenge.
The dataset comes from the US National Weather Service, and it recorded the maximum wind speeds at several locations.
Use the dataset to: - Find the county, location with the maximum highest wind speed at a given time - Rank the counties by average highest wind speed - Determine if the average highest wind speeds were before Noon or after Noon
First, prepare and the parse the provided input string into separate columns.