Count based on column value

[dholder15]

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. 

[DataNath · Accepted solution]

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 solution]

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)

[dholder15]

Thank you guys @Clifford_Coon @DataNath