Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Count Values 1's

neromerob
10 - Fireball

Hello.

I´m here because I need to do a count, the values are 0 and 1, and you gest it, I need the 1´s

field a.jpg

 

vlues.JPG

 

But the problem that I face is that the summary tool only considers count distinct from null.

 

summary tool.jpg

 

So not quite sure to do here, transform the 0 into null? Another tool?

 

 

 

Thank you.

2 REPLIES 2
IraWatt
17 - Castor
17 - Castor

Hey @neromerob,

you can get a count of the 1/0's by grouping by that fields values and counting them:

IraWatt_0-1655924878927.png

 

DataNath
17 - Castor
17 - Castor

As you're just using 0 and 1, you can just do a sum and this will act the same as a count of your 1s:

 

DataNath_0-1655925020382.png

 

Obviously if you want a count for the whole table, you can just sum these 2 fields with a formula tool.

 

Labels
Top Solution Authors