Challenge #288: Client's Rating Analysis

[brette]

solution

[Arran]

Awesome

[Dendri_773]

Solution attached 

[vizwithdan]

Solution :)

[phillipcjang]

Spoiler

 

[sai11]

my solution

[Tomasz101]

Done :)

[5ifar]

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.

[rebecca_petter]

Done

[Zongkai]

A good practice for summarise and sample tools.