Cloud Quest #13: Formula 1 Stats
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Maveryx,
We posted the solution JSON file to Cloud Quest #12. 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!
- Download and extract the provided JSON file containing your starting data and workflow files.
- Upload the provided Cloud Quest 13 - Start File.json file into your Analytics Cloud library.
- 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:
You are a big fan of Formula 1, and you want to run some simple statistics.
Your input data contains information about teams and their drivers from 2019 to 2021. Using this dataset, answer the following questions:
- What is the average age of all drivers in the field?
- Calculate the number podiums each team accumulated in 2019, 2020, and 2021. Which team accumulated the most total podiums, and how many did they accumulate?
- Which team had the biggest point differential between their best and worst drivers in 2021?
- Which country produced the most drivers, and how many drivers are from that country? (According to their Place of Birth)
Hint: Did you know you can create new columns based on a summarize function within one Cross Tab tool?
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in the Maveryx 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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I also built a solution in Standard Mode that uses the delta between seasons as the season data. For Task 3, Red Bull had the biggest point differential between their best and worst drivers in 2021.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator