Alteryx Academy

A solution to last week’s challenge can be found here.  Source: https://www.mashupmath.com/blog/expanded-form-with-decimals   This week's challenge is a two parter that will include a follow up challenge next week. For now, we dig into part 1!   If you've ever worked with continuous variables in Designer, you may have noticed that the values are left justified in the Results Window. This can make it a little more difficult to read your dataset. Convert the values provided into a table that lines up the decimals and has only one character per cell. ... 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

A solution to last week's challenge can be found here.  Source: https://en.wikipedia.org/wiki/Goaltender_mask   This Friday will be another Friday the 13th. Whether or not you consider yourself to be superstitious, odds are you're familiar with this dreaded calendar configuration.   But just how common are these occurrences? For this week's challenge, construct a workflow that provides a count of the number of Friday the 13ths for each year since 1900.   Bonus: Are there any years that don't have a Friday the 13th? ... View more

A solution to last week's challenge can be found here.    Palindromes are words that are spelled the same backwards as forwards. They aren't inherently better than other words, but they have a special name and we think that counts for something! Speaking of counting...   For this week's challenge, count the number of palindromes in the provided dataset. Also, find the most common starting letter for the palindromes and count the number of palindromes that begin with that letter. ... View more

Here is this week’s challenge, I would like to thank everyone for playing along and for your feedback. The link to the solution for last challenge #16 is HERE. This week’s assignment is listed as an advanced exercise due to the requirement of using a batch macro for the solution.   The use case: A bank is looking to calculate customer retention rate month over month. The denominator in the calculation are all of the accounts open 24 months prior to the start of the month. For example, for June 2013, the denominator would be the total number of accounts open between June 1, 2011 through May 31, 2013. The numerator will be total number of accounts closed in June 2013 or between June 1, 2013 through June 30, 2013.   The objective is to create a batch macro that calculates the retention rate for May, June, July and August. ... View more