SOLVED
Counting number of records in a column with a specific text
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
jonathonallen
6 - Meteoroid
‎09-17-2020
01:25 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My workflow output has 12 columns where each record is either "OPEN" or "CLOSED".
How would I create a summarized view where for each of the 12 columns, I can get the total count of "OPEN" and "CLOSED" records?
Solved! Go to Solution.
Labels:
- Labels:
- Common Use Cases
3 REPLIES 3
bpatel
Alteryx Alumni (Retired)
‎09-17-2020
03:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎09-21-2020
09:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was exactly what I needed. Thanks!
‎09-29-2020
11:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I went with view # 2 in the initial response, and now I want to find a way to add a $$ total (Each record that has the open/close columns also has a $$ total) What would be the best way to add a $$ total for CLOSED records to the summary table? Please let me know if a data sample would be helpful.