Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Cloud Quests
Elevate your workflow skills by solving real-world challenges using the Alteryx Analytics Cloud Platform.
I did a little extra.
Another one in the books.
Spoiler
I'm liking the new functionality in some of the tools, such as sorting in Sample. If only we could have multi-clause in the filter without having to drop into writing the whole thing out manually. Maybe an AND/OR button that opens another clause...
Anyway, I digress.
I simply ensured the "Interpret Column Datatypes" option is checked, otherwise you would need another Select tool to change the data types, filtered the Requests to only show where Status = "Evaluated", then joined on Client ID and RequestNumber.
The first task was then just a simple summarise grouping by the Right_Status field and counting the Professional column.
The second task was another Summarise tool grouping by Professional and calculating the Average of the Rating field. Then a sample tool was applied to sort descending on the rating field and sampling the first three.
Anyway, I digress.
I simply ensured the "Interpret Column Datatypes" option is checked, otherwise you would need another Select tool to change the data types, filtered the Requests to only show where Status = "Evaluated", then joined on Client ID and RequestNumber.
The first task was then just a simple summarise grouping by the Right_Status field and counting the Professional column.
The second task was another Summarise tool grouping by Professional and calculating the Average of the Rating field. Then a sample tool was applied to sort descending on the rating field and sampling the first three.
Here is my solution
