Summarize tool
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
AS
8 - Asteroid
‎07-13-2021
07:05 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Need to Calculate distinct Count of code against doc id.
Doc Id | Code | Distinct count |
8769 | 01- | 1 |
8770 | 02- | 2 |
8770 | 01- | 2 |
8770 | 01- | 2 |
8774 | 05- | 1 |
8780 | 02- | 3 |
8780 | 09- | 3 |
8780 | 01- | 3 |
8780 | 01- | 3 |
1160 | 03- | 5 |
1160 | 03- | 5 |
1160 | 09- | 5 |
1160 | 09- | 5 |
1160 | 09- | 5 |
1160 | 02- | 5 |
1160 | 02- | 5 |
1160 | 01- | 5 |
1160 | 02- | 5 |
1160 | 01- | 5 |
1160 | 02- | 5 |
1160 | 05- | 5 |
Labels:
- Labels:
- Bug
- Custom Tools
- Gallery
- Workflow
1 REPLY 1
atcodedog05
22 - Nova
‎07-13-2021
07:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @AS
You can do something like this. Calculate distinct count for Doc ID and joining it back.
Workflow:
Hope this helps : )