Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Counting number of records in a column with a specific text

jonathonallen
6 - Meteoroid

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?

3 REPLIES 3
bpatel
Alteryx Alumni (Retired)

hi @jonathonallen,

 

here is an idea 

bpatel_0-1600380077756.png

or this view

bpatel_1-1600380133811.png

hope this helps!

jonathonallen
6 - Meteoroid

This was exactly what I needed. Thanks!

jonathonallen
6 - Meteoroid

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.

Labels
Top Solution Authors