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.
If you're familiar with the Formula tool in Designer, you know that there aren't many things you can't do with it. But just because you can do something doesn't mean that you should. There are some tasks that can get a little repetitive when you have to do them over and over again. In those instances it can be more efficient to think about ways to make the process a little more dynamic. This also serves you well as you begin automating processes because it can keep workflows from breaking when datasets change.
For this week's challenge, we want to perform a simple calculation: divide each month's Tax value by its Cost value to find the Percentage. Since there are almost always multiple ways to accomplish the same task, go for a double dip and find two solutions to arrive at the final output.
... View more
I'm not sure if you know it, but Alteryx isn't the only organization that puts on a Grand Prix. Turns out they are pretty common for something called Formula 1.
This week's challenge gears up for the 2019 Grand Prix by taking a look at race data from 1950-2018. In Formula 1, points are awarded to the top 10 drivers after each race. After all the races in the year, the driver with the most points is named champion. Drivers also represent their teams in the "Constructor's Championship". (Constructor = Team) Use the provided data to find the youngest and oldest ever champions, and what team they drove for during that season.
... View more
Hi Maveryx,
A solution to last week’s challenge can be found here.
This challenge was submitted by Patrick Digan (@patrick_digan) an Alteryx ACE and also an active Community member who has contributed to many challenges before. Thank you, Patrick!
This week’s challenge is inspired by a special day that just passed: Pi Day! Not the delicious treat, but the number with an infinite sequence of non-repeating decimals: 3.14, which is celebrated on March 14.
In honor of pi, this week your task is to find all 13 numbers less than or equal to 100,000 that are equal to the n th power of the sum of their digits. For example, 81 is a 2-digit number, so n=2, and (8+1) 2 = 81; therefore, it falls under the category we are looking for.
For the input, use the Generate Rows tool to generate numbers from 0 to 100,000.
Bonus question: If you want to take your skills to the next level, you are invited to find all 17 numbers that are equal to any n th power of the sum of its digits. For example, 4,913 works for this. While it will fail for the first task because (4 + 9 + 1 + 3) 4 = 83,521, the number 4,913 works well for the bonus question since (4 + 9 + 1 + 3) 3 = 4,913.
Need a refresher? Review these lessons in Academy to gear up:
Summarizing Data
Creating Regular Expressions
Good luck!
... View more
A solution to last week's challenge can be found here. Source: https://www.flickr.com/photos/wkulicki/4010582747/
Did you know that professional golf tournaments start on Thursday and last through Sunday. The players compete on the first two days and only the players with the best scores are allowed to finish the tournament. This is referred to as "making the cut" and it comes with real consequences...money! Players who don't make the cut do not get paid, while everyone who completes the tournament receives a payout based on their final rankings in the tournament.
For this week's challenge, use the included dataset (which contains tournament results for the last 5 years) to find the 5 players with the highest earnings per event, and the top 5 players who have earned the most money without winning any events.
... View more
A solution to last week's challenge can be found here.
Have you ever reviewed a test and marked the wrong answer, only to realize that you overlooked the correct answer when evaluating your options? Humans are fairly unreliable when reading in data, especially when it isn't in a friendly format. Computers on the other hand...
For this week's challenge, create a workflow that identifies and highlights the largest value from a table of values. It should highlight only one value.
... View more