SOLVED
Table count
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
Tommy23
7 - Meteor
‎03-06-2023
03:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have this table and I would like to count the number of time for each row its wrote Alerted. I have try to group By using the tool summarize or create a formula (IF THEN ELSE IF)
Name | Sanction | Corruption | PEP |
Client 1 | Alerted | Alerted | Not Alerted |
Client 2 | Alerted | Not Alerted | Alerted |
Client 3 | Not Alerted | Not Alerted | Alerted |
Results:
Name | Sanction | Corruption | PEP | Number of Alerted |
Client 1 | Alerted | Alerted | Not Alerted | 2 |
Client 2 | Alerted | Not Alerted | Alerted | 2 |
Client 3 | Not Alerted | Not Alerted | Alerted | 1 |
Thanks in advance for your help!
Solved! Go to Solution.
Labels:
- Labels:
- Custom Tools
- Expression
- Transformation
2 REPLIES 2
17 - Castor
‎03-06-2023
03:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @Tommy23, how does this look?
The workflow:
1) Transposes the data so that all fields merge into one
2) Filters for the field value = Alerted
3) Performs a count grouped by name
4) Re-joins to the main data set
‎03-06-2023
03:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks a lot it's work perfectly!!
