Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Count based on column value

dholder15
7 - Meteor

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. 

3 REPLIES 3
DataNath
17 - Castor

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:

 

DataNath_0-1687273676597.pngDataNath_1-1687273689002.png

Clifford_Coon
11 - Bolide

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
7 - Meteor

Thank you guys @Clifford_Coon @DataNath 

 

Labels