Cloud Quests

Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.

Cloud Quest #17: Weather Permitting

AYXAcademy
Alteryx
Alteryx

Hi Community,

 

We posted the solution JSON file to Cloud Quest #16. Check it out and let us know what you think! Send suggestions to academy@alteryx.com or leave a comment below!

 

 

Let’s dive into this week's quest!

 

  1. Download the provided JSON file containing your starting data and workflow files.
  2. Upload the provided Cloud Quest 17 Start.json file into your Analytics Cloud library.
  3. All necessary datasets are contained within Text Input tools in the workflow.

For more detailed instructions on how to import and export Designer Cloud workflow files, check out the pinned article Cloud Quest Submission Process Update.

 

Scenario:

 

Marie lives in Toronto, Canada. Every spring, as soon as the weather permits it, she rides her bike to work. Her office is about 15 km away from her home if she drives her car, and a 12 km ride if she bikes.

 

On Tuesdays and Thursdays, Marie works remotely. On Mondays, Wednesdays, and Fridays, she has to go to into the office. If the temperature gets up to 28 degrees Celsius, she drives to work.

 

Use the dataset to determine:

- How many days did Marie bike and drive in April, May, and June 2021?

- How many kilometers did Marie bike and drive in April, May, and June 2021?

 

Use the “Max Temperature” information provided in the dataset.

Note: If the Max Temperature is NULL, assume it is a driving day.

 

** Data source: https://climate.weather.gc.ca/climate_data/daily_data_e.html?StationID=51459

 

Spoiler
A combination of the Filter, Summarize, and Formula tools should solve your problem, but not necessarily in this sequence.

 

If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx Academy for guidance:

 

Once you have completed your quest, go back to your Analytics Cloud library.

  • Download your workflow solution file.
  • Include your JSON file and a screenshot of your workflow as attachments to your comment.

 

Here’s to a successful quest!

 

 

 

5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

I am the first? 😂

 

Spoiler
1. "gets up to 28 degrees " means "gets above to 28 degrees ", But the Max Temperature for Jun-30,2021 might be wrong. 54C can kill. 
2. Going to office is NOT a single way trip.
Cloud Quest 17.png

 

 

alexnajm
17 - Castor
17 - Castor

You are @Qiu ! I'll take second 😊

Spoiler
quest 17.jpg
AkimasaKajitani
17 - Castor
17 - Castor

My solution! 3rd!?

 

Spoiler
image.png
patrick_digan
17 - Castor
17 - Castor
Spoiler
image.png
geoff_zath
Alteryx
Alteryx

Maybe the temperature condition needs to be clarified? It should be >= 28 C as written, not >28 C in the solution.

Spoiler
quest_17_workflow.png