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

NISCHITHA-98
5 - Atom

Solution

jacekDziuba
6 - Meteoroid

my solution attached. Thanks for creating challenges!

 

 

I did it in this way.

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1633425899505.png

 

Toons_1-1633425917845.pngToons_2-1633425932931.png

 

 

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1633434842973.png

 

galmahalal
7 - Meteor

Here is my solution for the challenge.

 

Just one thing - it should be possible that there are requests without related customer in the customers table?
I think that the "right" part from the join should be blank - no requests without related customers. And if not, we should calculate the data from there also 🙂 

 

Thanks for that!

 

DaisukeTsuchiya
12 - Quasar
Spoiler
キャプチャ.JPG

EDUAN_Swanepoel
5 - Atom

see attached my solution

chukleswk
7 - Meteor

Here is my solution:

 

Spoiler
Spoiler
Results.JPG

martin-krejci
6 - Meteoroid
Spoiler
martinkrejci_0-1633451782301.png