This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
A solution to last week's challenge can be found here!
We are thrilled to present another Challenge from our “Think like a CSE” series, brought to you by our fearless team of Customer Support Engineers. Each month, the Customer Support team will ask Community members to “think like a CSE” to try to resolve a case that was inspired by real-life issues encountered by Alteryx users like you!
This month we present the case of ranking ratings in descending order. Below, we’ve provided the information that was initially available to the Customer Support Engineer who resolved the case. It’s up to you to use this information to put a solution together for yourself.
The Case: A User is trying to create a column of rank for an input dataset. Like the Rank function in SQL, we want to return the rank of each row within the partition of a result set. The rank of a row is one plus the number of ranks that come before the row in question. Please see the images below for an example.
Ranking data
Your Goal: Create a Rank column like the Rank function in SQL.
... View more
A solution for last week's challenge has been posted here in both video and workflow forms!
This week's Challenge lets you get crafty! Create an app to allow a user to search a list of craft canned beers by state of origin or beer style. Configure the app's interface to utilize radio buttons to expose the selection elements for each selection option: a Text Box for searching by state, and a Drop-Down for beer styles. Feel free to customize the app as you see fit!
... 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
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 #09 is HERE. For this challenge let’s look at the date and time functions in Alteryx.
The use case: A distribution center receives a package. At the point of receipt, the package is scanned and a timestamp is captured for arrival date/time. The company is trying to reduce the amount of time the package is at its facility and as a result is trying to analyze how long packages remain at the facility.
The objective for this challenge is to calculate the delta between arrival date/time and the Time_Now field (this field has the date/time of the creation of this challenge and will be changing as time goes on). Create a unique field for Days, Hours, Minutes and Seconds.
We have listed this as an intermediate exercise and I expect it will go very quickly for many of you. Let us know what you think, we are looking forward to hearing your feedback.
UPDATE 2/1/2016
You can find the solution below.
... View more
Congratulations on completing Exercise 4!
When you are ready to submit your solution, click "Reply" to this post and upload your workflow.
You may also download and review the attached solution.
... View more
