Cloud Quest #28: Where There's a Whale There's a Way

[AYXAcademy]

Hi Community,

We posted the solution JSON file to Cloud Quest #27Check 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 and extract the provided ZIP file containing your starting data and workflow files.
2. Upload the provided Cloud Quest 28 Start.json file into your Analytics Cloud library.
3. Reconnect the provided Whale_Migration_Data.xlsx, Whale_Pods.xlsx, and Whale_Species.xlsxdatasets to your starting workflow file.

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:

Every year, whales around the world migrate from their feeding grounds to their breeding grounds. Some species travel an astounding 12,000 miles round trip! In this week’s Cloud Quest, you will analyze migration movements for different whale species using the provided datasets.

Datasets:

• Whale_Migration_Data: Contains a list of whales tracked from 2001 to 2003, along with the total kilometers each whale swam daily during their migration.
• Whale_Pods: Lists whale IDs and their corresponding pod IDs, indicating which pod each whale belongs to.
• Whale_Species: Provides information about the species of each pod.

Your Tasks:

1. Calculate the total number of kilometers each pod swam during migration for each year.
2. Determine the average number of kilometers each whale in a pod swam (total kilometers/number of whales in the pod).
3. Identify the pod with the highest average kilometers swam per whale for each species and each year.

Data Source:

While whale migration is a real phenomenon, these datasets are fictional. To learn more about whale migration, visit: https://www.oceanicsociety.org/blog/2193/the-gray-whale-migration-in-california-and-beyond.

Hint: Pay attention to the order of group by and sort by columns in your Summarize and Sort tools.

Spoiler

A combination of the Summarize, Join, Sample, Sort, 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 Alteryx Academy for guidance:

• Getting Started with Designer Cloud
• Building Connections in Designer Cloud
• Building Your Workflow in Designer Cloud

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!

Download Start File | Download Solution File

[JeffF]

I kept the typo in the column name so they match.

Spoiler

[Carolyn]

Solved! I tried leaving the typo like @JeffF but my eye started to twitch so I fixed it 😆

Spoiler

[Qiu]

@JeffF @Carolyn 
Nice catch.😁

Spoiler

[RWvanLeeuwen]

Easy challenge - but alas no spatial data :'-(

Spoiler

the webassembly ensures my browser power consumption skyrockets with these basic dataprep tasks I know it is unfinished, but I cannot afford to wait as long as this workflow needs to finish

[alexnajm]

Done!

Spoiler

[patrick_digan]

Spoiler

[ggruccio]

I had to think about the logic a bit!  Count distinct!

Spoiler

[AkimasaKajitani]

My solution!

Spoiler