We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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
16 - Nebula
16 - Nebula

Solution attached,

 

Spoiler
PhilipMannering_0-1633349821483.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Solution in Python Tool

 

Spoiler
PhilipMannering_0-1633350878677.png

 


 

binuacs
20 - Arcturus
Spoiler
binuacs_0-1633350839255.png

 

AkimasaKajitani
17 - Castor
17 - Castor

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