Alteryx Academy

A solution to last week’s challenge can be found here. calendar.png This week's challenge can be solved using either Designer Desktop or Designer Cloud.   Almost any data project will include dates. Working with dates is a common task and is important for downstream tasks such as reporting. In this week's challenge, we are going to cover a common date manipulation that many will encounter.   In this scenario, we have a column of date data that is in the format of MM/dd/yyyy. We want to reformat that data to yyyyquarter. Your goal for this challenge is to convert the date format from MM/dd/yyyy to yyyyquarter. As an example, change 2/15/2023 to 2023Q1. ... View more

Hello Community Members,   A solution to last week’s challenge can be found here.    We are excited to kick off our series of Weekly Challenges submitted by User Group members! Over the next 4 weeks, we will be featuring challenges submitted as part of our Weekly Challenge User Group October Takeover event. Thank you to everyone who submitted their challenges!   The first challenge in this series comes from Jessica Emerson (@jessemers), a member of the Houston User Group. Thanks, Jessica, for this fantastic contribution!   The World Happiness Report polls over 100,000 people in over 130 countries annually to determine happiness rankings. The main life evaluation question asks respondents to think of a ladder, with the best possible life for them being a 10 and the worst possible life being a 0. They are then asked to rate their own current lives on that 0 to 10 scale (Ladder Score). The columns following the happiness score are variables based on observed data for six factors: economic production, social support, life expectancy, freedom, absence of corruption, and generosity. The report uses these variables to help explain the happiness ranking variation across countries.   The provided datasets include the World Happiness Report data for 2023 and 2024.   Your task is to use the provided datasets to answer the following questions: Which year had the highest average happiness score? For each year, which is the highest-scoring country with a gross domestic product (GDP) under 1? Which five countries had the highest average generosity factor over the 2-year period? Bonus task: How high is your country’s happiness score?   Happy solving!   Data Source: World Happiness Report Data Dashboard   The Academy Team ... View more

Hi Maveryx,   A solution to last week’s challenge can be found here.   Our ACE, John Hollingsworth (@Hollingsworth) , is the creator of this Weekly Challenge. Thanks, John, for your contribution!   For this task, you will use a sample of Florida population data downloaded from the US Census Bureau.   Your tasks for this challenge are: Sum all the values for each GEO_ID and create a column named Total. Calculate the percentage each column represents of the total, and round the number to two decimal places.   Need a refresher? Review the Changing Data Layouts lesson in Academy to gear up.   Good luck!   ... View more

Hi Maveryx, a little earlier than usual!   A solution to last week’s challenge can be found here.   We are thrilled to present the second and final challenge in the spirit of the Maveryx Summer Cup 2024 that runs from July 24 through August 11, 2024. During the event, you can complete many different activities in Community, including this challenge and any other published Weekly Challenge or Cloud Quest to earn points and win a medal that will appear as a badge on your profile,.   We would like to take a moment to acknowledge ACE Calvin Tang (@caltang)  for his outstanding contributions to our Community. Thank you, Calvin, for being an active member and providing us with this fantastic idea as part of our campaign to feature user-submitted challenges for special occasions!   In Part 1, you discovered that there are athletes competing in sports from various constellations in a universe-wide event! Every summer these extraterrestrial athletes meet and compete across the galaxy in the Universal Summer Cup.   The dataset provided contains statistics from 40 Universal Summer Cups. It is vertically sorted, which is not a common practice for data analysis. However, this is a familiar scenario for our users, who often deal with messy and unstructured data.   Your task is to identify the Summer Cup where each constellation (team) earned its highest total medal count (gold, silver, and bronze). The performance metric is the total number of medals won, and the final output should be a unique list of constellations, the Summer Cup event when the constellation performed its best, and their total medal tally (if there is a tie in the number of medals, consider the most recent Summer Cup).   Need a refresher? Review the following lessons in Academy to learn more and earn points during the event: Multi-Field Formulas Separating Data into Columns and Rows   Good luck!   ... View more

  Hi Maveryx,   A solution to last week’s challenge can be found here.    Are you a big fan of Formula 1?    This challenge is an exciting part of the Alteryx Formula 1 Fanalytics event.    Rev your engines and get ready to race to the finish. Your goal is to analyze driver lap time data and pinpoint the best driver in rainy conditions, making them the top choice for any wet race conditions.     Bonus: Tune in to a recording of the “Alteryx + McLaren: Formula To Success with AI & Analytics” webinar to hear from McLaren Racing CEO, Zak Brown, and Alteryx CIO Trevor Schulze on how McLaren and Alteryx ride the data wave using AI and analytics to conquer change.    Source: All data provided for this challenge is entirely fictional. ... View more