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.
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
We hope you enjoyed last week's challenge. For the sixth challenge lets look at some of the geospatial capabilities in Alteryx.
The challenge for week 6 will focus on analyzing distance traveled by sales reps.
Sales reps are travelling all over the US. The data contained in the workflow details the travel paths for 7 Reps to 7 different cities. The travel route is detailed as well. The objective of this challenge is to determine which Rep has logged the most miles. Please include the route traveled as a spatial object in the output.
We have listed this as an intermediate challenge since not everyone is familiar with the Spatial tools. As always, we love to hear your comments. We hope you are having fun with the challenges !
... View more
Here is this week’s challenge , I would like to thank everyone for playing along and for your feedback. You can find the solution to the previous challenge here.
For this challenge let’s look at creating a multi-level hierarchy from employee-manager data. As always there are several ways to do this challenge , I have designated it as an advanced challenge because there is an elegant way to solve it using iterative macros. The advantage to the iterative macro solution is that it becomes very dynamic. Other hard coded solutions would get you to the answer with this data, but if the depth of the hierarchy were to change, you would have to modify the workflow to support the change. It is a great example to see how iterative macros can make a workflow dynamic.
The use case:
An HR department wants to use Alteryx to quickly understand the reporting structure for employees across their organization.
The Input source contains 5 employees and an identifier that uniquely identifies the individual and the manager they report to.
The goal is to create a hierarchy field identifying each relationship between employee and manager(s). For example, a Director reports directly to the Vice President which is 1 level up. The Director is then 2 levels away from the CEO (in this data set). As a result the hierarchy identifier represents how many levels removed the employee is from management team they report into.
Give it a try, I look forward to your feedback.
The Solution has been included.
... View more
Happy New Year, and welcome back to Weekly Challenge! Here's to another year of stretching our skills, exploring new tools and encouraging each other to be the best Alteryx-ers we can be!
Today is a day that so many of you have awaited: Challenge #100! Not only do you earn bragging rights for completing 100 Challenges but this Challenge also gets you another shiny badge to add to your collection! We have 8 Challengers who are neck and neck with 99 completed Challenges, with a couple more contenders not too far behind. Check out the updated Weekly Challenge Index to see the current standings. Ready to get started? We're off to the races!
After a very busy 2017, @Ned really needed to get away from it all. So, he did what any of us would do: he set up his tent in the farthest location from any road in the state of Colorado. But, now it’s 2018 and we’re all ready to get back to work on completing the newest course of Interactive Lessons, passing the Advanced Designer Certification exam and preparing for Inspire 2018. All of us…except for Ned. Where exactly is Ned? And how quickly can we find him? Well, that's what you need to figure out!
You are provided with two Input datasets: ColoradoRoads.yxdb, which contains spatial data of all the roads in Colorado, and Colorado.yxdb, the administrative boundary of the state. Using these two files, you need to not only find the location of Ned's tent (within 100 meters of the correct answer) but also locate him the fastest you possibly can. You'll notice that the start file for this Challenge does not include the solution! To check the accuracy of your solution, plug your final coordinates into the app called "HowCloseIsNed", which is attached to this post. Not within 100 meters of Ned's tent? Can’t find him within a few minutes? Optimize your process, and try again! Share your results for distance and run time when you post your solution.
Due to file size limitations we can not attach the files to the post,please download by selecting: challenge_100_start_file.yxzp and HowCloseIsNed.yxwz
... 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
Congratulations on completing Exercise 2!
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