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

brette
8 - Asteroid

solution

Arran
8 - Asteroid

Awesome

Dendri_773
5 - Atom

Solution attached 

vizwithdan
8 - Asteroid

Solution :)

phillipcjang
8 - Asteroid
Spoiler
challenge_288.png

sai11
7 - Meteor

my solution

Tomasz101
6 - Meteoroid

Done :)

5ifar
6 - Meteoroid

Challenge #288 BF: Client's Rating Analysis - My Workflow Solution

Spoiler
Idea Flow:
Task 1:
1. Select only relevant fields.
2. Filter [Status] = "Evaluated". Filter [Status2] = "Below Expectations" OR [Status2] = "Exceeded Expectations" OR [Status2] = "Met Expectations".
3. Join the input sources on Client ID & RequestNumber fields.
4. Summarize the data: Group by Status2 field & Count Professional field values.
Task 2:
1. Select only relevant fields.
2. Join the input sources on Client ID & RequestNumber fields.
3. Summarize the data: Group by Professional field & Average Rating field values.
4. Sort Avg_Rating field in Descending order.
5. Sample the top 3 records.
My Challenge 288 Solution Task 1.PNGMy Challenge 288 Solution Task 2.PNG