Cloud Quests
Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.
Hi Maveryx,
We posted the solution JSON file to Cloud Quest #8. 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!
- Upload the provided Cloud Quest 9 - Start File.json file into your Analytics Cloud library.
- The necessary datasets are pre-populated in the Text Input tools.
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:
In this week’s quest, a general contractor needs your assistance assessing his business using date-time analysis.
Bob, who had been working as a home builder, decided to transition his business towards leasing construction equipment. Among other equipment, he has two cranes he has been leasing for a while. He wants to get a better idea how his crane leasing business has been going.
Create a workflow that will show how many days both of his cranes have been leased at the same time during the years 2016-2018, the only years where he has a full set of data for both cranes.
Hint: In Designer Desktop, the Generate Rows tool would be the most efficient way to tokenize records within a date range. Unfortunately, the Generate Rows tool is not yet available in Designer Cloud (coming soon in 2024!), but you can still solve this quest thinking outside the box with a cartesian join from the Append Columns tool.
A combination of the Summarize, Filter, Append Columns, Formula, and Sample 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:
- 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!
All right, you can make a little bit of fun of me for this one because a.) I used Cloud Native mode when I could have used the "standard" mode and made it MUCH easier. But I thought I'd restrict myself to the same limitations others had when Cloud 9 hit the community (e.g. no standard mode, so no generate rows). And b.) I was thinking "on canvas" as I went and had a few ideas bouncing around, so my workflow has some extraneous bits that I didn't clean up as I moved between ideas. And c.) I'll admit, I completely forgot the +1 at first for date calcs (that's not much of a spoiler) and I wasted some time walking back through it to see if I'd messed up my dates anywhere else before I realized the problem.
