Challenge #288: Client's Rating Analysis

[AYXAcademy]

A solution for last week's challenge can be found here.

For this  week's challenge, you are provided two datasets:

- 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

[AJ_23]

My Solution

[MartWClimber]

Here is my solution.

use the formula tool to get the average rating of 5 or higher.

What I find interesting is that a lot of people use the sort and sample tools in there solutions?

is there a specific reason for this?

[TonyAdam]

Not really a challenge

Spoiler

[allwynthomas24]

Spoiler

[ahmedirfanp]

My Solution to this challenge

[Anmol97]

Here's my solution

[ALexAn]

Spoiler

[Erin]

Spoiler

[cafkhami]

My solution. A pretty straight forward one.

[TapasTR]

May be because one does not wish to assume that top 3 ratings are necessarily above 5!