Alteryx Academy

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!   ... View more

A solution to last week’s challenge can be found here.   To solve this week’s challenge, use Designer Desktop.   This challenge comes to us from @Pawel_Paleczny  Thank you for your contribution.   The FIFA World Cup is currently taking place in Qatar. Pavel would like to perform analyses on the event.   The first dataset contains information about the stadiums: stadium name, city, capacity, latitude, and longitude. The second dataset contains information about the events: match number, round, dates, location, which teams are playing, and the group or phase.   For this challenge: 1. Assuming that each match will have a full audience, find the top 10 teams that could have the largest audience in the group stage. 2. Find the three cities with the most World Cup matches. ... View more

Happy New Year, Community Members!   A big thank you to Erin Miller (@Erin)  for this special submission. Erin, you've contributed so many fantastic challenges throughout 2025, and it’s only fitting that Challenge #500 comes from you. We truly appreciate your creativity and dedication. Thank you again!   A solution to last week’s challenge can be found here.   It’s 2026: time for resolutions, fresh routines, and rethinking your media diet.   Your friend has been deep into true crime podcasts, so deep, in fact, that their spouse is starting to give them some serious side-eye. It’s clearly time for a change: something lighter, brighter, or just totally different.   Luckily, you’ve come across a daily dataset of Spotify’s Top 200 Podcast Episodes, complete with detailed show and episode info from the Spotify API. What better way to kick off the new year than with a chained analytic app to help your friend discover their next podcast obsession?   Your 2026 Podcast Discovery App – Let’s Build It!   Create a chained app experience where each selection refines the next. The app should include the following filters:   App 1 – Filter by Region App 2 – Filter by Language (Feeling a little extra? Let the user select multiple languages!) App 3 – Filter by Average Podcast Duration (Really feeling extra? Group durations into 15-minute intervals for a smooth user experience!)   After all filters have been applied, calculate the average show rank and identify the top-ranked episode for each show. The final result should include a summary of the selected filters and a table displaying the top 10 shows by average rank, along with the show description, average show duration, publisher, highest-ranked episode, and episode description.   Did you know that Alteryx has a podcast within the Alteryx Community? Check out the Alter Everything Podcast here: https://community.alteryx.com/t5/Alter-Everything-Podcast/Alter-Everything-Podcast-Episode-Guide/ba-p/450065    Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.   Good Luck! The Academy Team   Source: https://www.kaggle.com/datasets/daniilmiheev/top-spotify-podcasts-daily-updated    Download Start File ... View more

A solution to last week’s challenge can be found here. "Pumpkins Halloween 2013" by Mod Mischief is licensed under CC BY-SA 2.0   Pumpkins abound, and squirrels are happy. It’s that time of the year! Halloween is in just a few days, and you need to get candy for trick-or-treaters.   This Halloween dataset contains 85 types of candy. Take a closer look at the columns: - sugar percentage - The percentile of sugar it falls under within the data set. - price percentage - The unit price percentile compared to the rest of the set. - favorite percentage - The overall win percentage according to 269,000 matchups. Your house is going to be a hit if your candy basket includes the following: - The 5 candies with the lowest “sugar percentage”. An average trick or treater consumes 7,000 calories worth of candy, so you want to offer some healthy options. - The 5 candies with the highest “favorite percentage”. Your neighbors know you are a people pleaser! - The 5 candies with the lowest “price percentage”. The giant tarantula inflatables you bought weren’t cheap, so you need to save some money on the treats.   And no peanut or almond candies. The teal pumpkins at your front door communicate that your candy basked is allergy-friendly. (Did you know that’s a “thing”?)   Hint Make sure to filter out all candies that are not allergy friendly first.   Among the 85 types of candy from the dataset, what are the 15 candies to have in your basket? ... View more

A solution to last week's challenge can be found here.   The Billboard (magazine) is a weekly American music and entertainment magazine that provides music charts. The Hot 100 lists the 100 most popular songs of the week in the US.   This dataset contains information about the Top 100 most popular songs between 2015 and 2021. Find out the top 5 artists and songs who stayed on the chart the longest (weekly) for each in 2017, 2018, 2019, 2020. Then create a table in the format of your choice to display your results.   Hint: The column "Weeks on Chart" shows how many weeks the song was on the charts since its launch. ... View more