Challenges & Quests

The solution to last week's Challenge can be found HERE!   It's that time of year again....the leaves are starting to change color, the smell of pumpkin spice is in the air, and the amount of daylight for @JoeM's post-work bike rides is getting smaller and smaller.  Just how much daylight did we lose this month?  Take this week's Challenge to find out!  Using the Input data provided, calculate the amount of daylight for each day in September, as well as the day-to-day differences in daylight and the total difference from September 1 to September 30.    *If you'd like to use a dataset for your location, you can download data on sunrise/sunset times from this site: https://www.timeanddate.com/sun/usa/ for US-based users.    ... View more

We are one week away from the challenge #75 milestone. Some users want to race this one to be the first to 75 and nab the first ever ‘Burgschrund Crevasse’ badge. I will plan to post the challenge on 6/26/2017 at 9:00 AM PST. The main contenders are  @SeanAdams, @NicoleJohnson, @LordNeilLord, and @estherb47 barring any other users catching up on a significant amount of challenges this week.   This week, we are going to slow it down and take a breather after our two-week long challenge #73 and shoot for something simpler. This week, the goal is to create a macro that calculates factorials. To find the exact formula, you can find it here: https://en.wikipedia.org/wiki/Factorial. Factorials are commonly used to calculate the multitude of ways a task can be completed – like how many possible results could come from shuffling  52 playing cards. Factorials are usually represented by ‘n!’ – n being an integer. If we were looking for the factorial of 4, it would be represented as 4!. To calculate the factorial of 4, the equation is written as (4)*(3)*(2)*(1). Below are some example caculations. 1! = (1) = 1 2! = (2)*(1) = 2 3! = (3)*(2)*(1) = 6 4! = (4)*(3)*(2)*(1) = 24 ... View more

Hi Community members,   A solution to last week’s challenge can be found here.   This challenge was submitted by @AkimasaKajitani. Thank you, Aki, for your submission.   The Alteryx Community hosts localized User Groups across the globe. Have you ever wondered how many people participate in these groups, or how many active groups exist?   Each User Group page displays the group name, the number of leaders, the number of members, the URL, and the region. The dataset below was created by web scraping User Group pages between June 2023 and March 2025. You can explore it here: Alteryx Community User Groups.   For this challenge, use the two datasets provided to complete the following tasks:   Calculate the total number of User Groups, the total number of members, and the percentage increase in membership between June 2023 and March 2025. Identify the top five User Groups with the largest increase in members.   Notes: Task 2 applies only to User Groups that exist as of March 29, 2025. Some User Groups may have changed names during the data period. Use the Change history dataset to align names correctly. Round all calculation results to two decimal places.   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   Download Start File | Download Solution File   Source: https://community.alteryx.com/t5/User-Groups/ct-p/usergroups  ... View more

The solution to last week's challenge is HERE!     Today we’re challenged to find the total area (square miles) that we can move our company headquarters to such that it is an equidistant commute from 3 satellite offices. In order to do so, find the area that is shared by a 30 minute drive time radius starting from each of the satellite offices!   Be warned! You may arrive on different areas depending on the spatial data release that is used, in addition to the drivetime methodology selected. For the sake of comparison, use the above map as an estimation of the area if you are not using the Q2: 2016 TomTom US Peak Most Recent Vintage dataset. If you think you need a hint, expand the spoiler below!   This week's challenge is inspired by the methodologies covered in our Trade Area Tool Mastery article from the Knowledgebase. If you're having trouble, try mastering the Trade Area Tool first!   ... View more

The solution to last week's challenge is HERE.     Today’s challenge is for all our investors out there! Say you wanted to perform your own unique analyses on a stock, or at least have its trends handy for notification if it was hitting an established threshold of yours. How would you obtain this data?   For our challenge, we’ll be using Yahoo Finance! Use the URL below to gather useable (parsed; tabulated format) stock data on AYX (Alteryx!): http://ichart.finance.yahoo.com/table.csv?s=AYX   As of May 2017 - the Yahoo API has closed its service. Instead please use the following URL to get historical data: https://www.google.com/finance/historical?output=csv&q=AYX *Due to differences in the API services - there will be no field in the resulting response for "Adj Close"   As of December 2017, the previously used URL produces an error.  We've updated this Challenge to point to a new link to download a dataset on attributes of mushrooms.  The Start File and Solution have been updated to reflect this change.  Happy Challenging! ... View more