In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
Cloud Quests
Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.
Here is my solution
I am flying with these.
Spoiler
I first applied a filter to isolate those records for Females with Grade 8 and the years which contained 2013 or 2019.
I then used a Summarise tool to create groupings of District, Year and Level 4 Percentage.
From there I simply sorted into the correct order and cross-tabbed to create a row per district, with the Percentage of Level 4 split into columns. It was then a matter of calculating the difference between the two.
For task two, it was a simple sort and sample to highlight the top three.
I then used a Summarise tool to create groupings of District, Year and Level 4 Percentage.
From there I simply sorted into the correct order and cross-tabbed to create a row per district, with the Percentage of Level 4 split into columns. It was then a matter of calculating the difference between the two.
For task two, it was a simple sort and sample to highlight the top three.
Another quest completed!
Things I liked
- Sorting built directly into the "Sample tool
Things I didn't like:
- The lack of the "Cross-Tab" tools ability to dynamically pick up changes to columns. For example, if I decided I wanted to compare two different years, I would have to click "Reset" in the cross-tab tool to pick up the additional columns
