Count based on column value

Question

Hi,

I'm trying to count the number of actives based on this dataset and the number of terminated. Everytime I put into Alteryx to do a formula it returns an error message. I essentially know that in order to summarize this data I would have to have the column created a double, just not sure what the next steps should be. Let me know your thoughts.

Test.xlsx

DataNath · Accepted Answer

Hey @dholder15, do you mean like this? If so, you can just use a Summarize tool to group by the field and then perform a count:

Clifford_Coon · Accepted Answer

Hi @dholder15 ,

What you can do is do a group by and a count of the Field, that will give you the count and description of each.

(like what @DataNath said) -(he was quicker)