We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #288: Client's Rating Analysis

AYXAcademy
Alteryx
Alteryx

A solution for last week's challenge can be found here.

 

For this  week's challenge, you are provided two datasets:

image_288.PNG

 

- The first one (Clients) contains each client's information including their Client ID
- The second one (Request & Evaluation) contains the client's Request number (which is the same as the Client ID),  "Status" which indicates if the request has been processed, "Status2" provides a comment, and the "Professional"  field is the name of the customer.

 

Your tasks are to determine:

- For a "Status" of Evaluated, the number of customers ("Professional") who commented "Below Expectations", "Exceeded Expectations", or "Met Expectations" for "Status2"
- The three customers ("Professional") who provided the highest average rating

JITHINPR
8 - Asteroid

mySolution

JasonHu
8 - Asteroid

Here is my submission.

Spoiler
workflow.png
PhilipMannering
14 - Magnetar
14 - Magnetar

Solution attached,

 

Spoiler
PhilipMannering_0-1633349821483.png

 

PhilipMannering
14 - Magnetar
14 - Magnetar

Solution in Python Tool

 

Spoiler
PhilipMannering_0-1633350878677.png

 


 

binuacs
8 - Asteroid
Spoiler
binuacs_0-1633350839255.png

 

AkimasaKajitani
15 - Aurora

My solution.

 

Spoiler
AkimasaKajitani_0-1633352592292.png

 

nickhernigle
6 - Meteoroid

Here is my solution. 

justindavis
10 - Fireball
Spoiler
challenge_288_solution_jdavis.PNG
Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1633354527192.png

 

Cheers!

Phil