Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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.

SUBMIT YOUR IDEA

Challenge #280: Weather Permitting

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found here.image_280_weather.PNG

 

Marie lives in Toronto (Canada). As soon as the weather permits it, she will take her bike to go to work. Her workplace is about 15 km away from her home if she drives her car and 12 km if she bikes.

 

On Tuesday and Thursday, Marie works remotely. On Monday, Wednesday and Friday, she has to go to her workplace.

When the temperature gets to 28 degrees, she will drive to work.

 

Use the dataset to find out:

- How many days of biking and driving Marie has done over April, May, and June 2021
- How many kilometers of biking and driving Marie has done over April, May, and June 2021

 

Use the “Max Temperature” information provided in the data set.

 

For this challenge, 2 solutions will be posted next week.

Aaron_Harter
11 - Bolide

Great day for a bike ride!

Spoiler
0.PNG
JasonHu
8 - Asteroid

Here is my submission.

Spoiler
workflow.png
DeanWest
9 - Comet

Fun and easy challenge to start the week!

Spoiler
challenge_280_solution_DeanWest-snippet.jpg
Blake
12 - Quasar

280 is in the books! 

 

Spoiler
280.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1628515740875.png

 

dYoast
11 - Bolide

Another one down.

Spoiler
dYoast_0-1628516910548.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached, 

 

Spoiler
PhilipMannering_0-1628517308642.png

And in the Python Tool,

Spoiler
PhilipMannering_1-1628521484750.png

 


 

 

binuacs
21 - Polaris
Spoiler
binuacs_0-1628517557068.png

 

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

I do have a couple concerns about the logic of when she'd ride her bike verses drive. For example, a Max temp of 4.7 degrees means that it will reach that temp around 3pm, but her morning commute would actually be around -4.2 degrees. We are also completely ignoring days when its rainy or that have wind speeds in excess of 40 kmph.

Spoiler
Maskell_Rascal_0-1628517751919.png

 

Cheers!

Phil