Today we completed a few Alteryx challenges!
If you want to take a stab for yourself, here is the challenge link: challenge link
Before we start, let's take a look at the data, and what we want to complete:
The first thing we want, is a list of 4-year colleges, from the year 2020.
We can complete this first step by using the filter tool, and creating a custom filter looking for the year 2020 and a length of 4 years.
This is what the data looks like after that first step:
As we can see, the only years shown are 2020, and the only lengths are 4 years.
we then select the fields we need for the output, which are State, Type, and Value
From here, we're interested in the total amount per state by type.
This can be done by using Cross tab, and summing the values.
Lastly, we sort this by state ascending, so we get an alphabetical order.
This satisfies our first half of the challenge!
Now, lets take a look at the second half of our challenge.
In this half, we care about the total discount for in-state vs out-state students.
We can complete this by using a formula to get the discount:
We then select the fields we want with the select tool:
We then sort by descending to prepare for top 10 schools:
lastly, we look for the top 10 by using the sample tool:
This completes our challenge!
Here is the full workflow:
Happy Data Prepping!