Dive deeper into solving problems with Alteryx, explore new frontiers in your analytics journey, and push yourself to prove and improve your skills with our Certification Program.
Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.
Also available in...
A solution to last week's challenge can be found here.
In celebration of the Data Connections window and many other cool new features in the 2019.3 release, this challenge requires you to read in thousands of files across 15 different file formats: yxdb, sz, avro, csv, shp, gml, sav, json, mif, tab, xlsx, xlsm, qvx, sas7bdat, geo. Each file contains a single value. Report back the sum of all values.
Hint: suffix FileFormat yxdb 19 sz 16 avro 48 csv 0 shp 12 gml 31 sav 46 json 54 mif 10 tab 14 xlsx 25 xlsm 56 qvx 47 sas7bdat 45 geo 15
... View more
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
The solution to last week's challenge can be found HERE.
This week, we get back to spatial! A wireless carrier wants to geolocate or triangulate the location of a device/user based on the location of nearby cell towers and the device/user by determining the azimuth. As a result, they would like to calculate the angle (in degrees) between two points where a line is drawn from the lower point directly horizontally towards the other point.
Bonus: Try solving one way with the spatial tools, and another using no spatial tools!
... View more
This challenges focuses on charting the changes in the minimum wage over time since 1968.
For those not familiar, the minimum wage is the lowest hourly wage allowed by law. In the United States, there is a federally mandated minimum, but each state is allowed to enforce their own minimums. Below, you will find a file containing minimum wage data from 1968 - 2017 by state. The Text Input tool classifies each state into a region.
Use the inputs to create a()n (interactive) chart showing each region's average minimum wage by year.
Source: GIPHY
... View more
A solution to last week’s challenge can be found here.
Roland van Leeuwen submitted this idea a while back, and now is the right time to share it! With 2024 approaching, let's determine our unique lucky numbers. Thanks, @RWvanLeeuwen, for your contributions to our Community!
In the quiet town of Serendipity Springs, there exists a magical tradition linked to Kaprekar's constant. Residents believe that the enchanted number 6174 holds the key to unlocking good fortune. This mystical connection is celebrated every New Year's Eve, adding an air of excitement and mystery to the festivities.
Following the rules of Kaprekar's constant, the townsfolk take their birth year, arrange the digits in both ascending and descending order, subtract the smaller number from the larger one, and continue the process until they reach the magical number 6174. The number of iterations used in this process is believed to represent their individual lucky number.
For instance, if someone has 1977 as the birth year, the following process is applied:
(Note: To apply Kaprekar’s constant, the number should contain at least two different digits, and leading zeros are allowed).
Arrange the digits of 1977 in descending order: 9771.
Arrange the digits of 1977 in ascending order: 1779.
Subtract the smaller number from the bigger number: 9771 – 1779 = 7992 (first iteration).
Use the output of Step 3 and apply Steps 1 and 2 another time (second iteration).
Repeat until you get your result 6174.
9972-2799 = 7173 (second iteration)
7731-1377 = 6354
6543-3456 = 3087
8730-0378 = 8352
8532-2358 = 6174 (six iterations to get 6174 as a result)
If you were born in 1977, according to Serendipity Springs habitants, your lucky number is 6.
Long story, right? What is your challenge then?
Imagine using Alteryx Designer to validate Kaprekar’s constant and generate your lucky number!
Tasks:
Task 1: Validate the process that all four-digit integer numbers with at least two distinct digits will transform into 6174 when applying the rules of Kaprekar’s constant.
Task 2: Find the highest and the lowest number of iterations you need to transform any four-digit number into 6174 using this rule set.
Task 3: Determine your lucky number.
HINTS:
You can choose how you want to solve the challenge, but this is the route we would suggest:
Create an iterative macro to validate the process that all four-digit integer numbers with at least two distinct digits will transform into 6174 when applying the rules of Kaprekar’s constant.
Create a batch macro that uses your iterative macro to find the highest and the lowest number of iterations you need to transform any four-digit number into 6174 using this rule set.
Apply the batch macro to a workflow with your birth year to determine your lucky number. (We are using 1977 in our solution.)
Wishing you a Happy New Year from Alteryx Academy!
May the year ahead be filled with fantastic moments for everyone, and in 2024, get ready for new challenges, updates, and opportunities to strengthen your abilities!
Thank you for all your contributions to our Community in 2023!
... View more