Challenge #288: Client's Rating Analysis
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
brette
8 - Asteroid
05-27-2024
09:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Arran
8 - Asteroid
06-05-2024
04:14 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dendri_773
5 - Atom
06-07-2024
04:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
vizwithdan
8 - Asteroid
06-23-2024
06:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
phillipcjang
8 - Asteroid
06-28-2024
11:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sai11
7 - Meteor
07-20-2024
04:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Tomasz101
7 - Meteor
07-20-2024
09:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
5ifar
7 - Meteor
07-22-2024
09:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
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
8 - Asteroid
08-02-2024
03:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Zongkai
8 - Asteroid
08-06-2024
11:50 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator