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.

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
15 - Aurora
15 - Aurora

Solution attached,

 

Spoiler
PhilipMannering_0-1633349821483.png

 

PhilipMannering
15 - Aurora
15 - Aurora

Solution in Python Tool

 

Spoiler
PhilipMannering_0-1633350878677.png

 


 

binuacs
17 - Castor
Spoiler
binuacs_0-1633350839255.png

 

AkimasaKajitani
16 - Nebula
16 - Nebula

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