The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more 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
