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.
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
