Counting only rows with a 1

[Deano478]

Hey All,

I have a the below Dummy data set and what I need to do is only get a count of the rows per name that contain a 1 so if there is a 0 we don't care about it essentially.

so like in the case of Dean it should just be a count of 3 and so on.

This might be a simple task but I cant see  way to do it after trying various approaches already.

Sample data:

Name	Present_or_Not	Year
Dean	1	2023
Dean	1	2023
Dean	1	2023
Dean	0	2023
Dean	0	2023
James	1	2023
James	1	2023
James	0	2023
Liam	0	2023
Liam	0	2023
Liam	1	2023
Liam	1	2023
Liam	1	2023
Liam	0	2023
Liam	0	2023

Cheers to you all in advance.

[FinnCharlton · Accepted solution]

Hi @Deano478 , you can do this by filtering to just the '1's and then counting the rows:

Another approach could be to replace the 0s with NULLs and then use the "Count Non Null" functionality of the summarize tool. Hope this helps!

[binuacs · Accepted solution]

@Deano478 One way of doing this with the summarise tool after changing the 0's to NULL value

[ShankerV · Accepted solution]

Hi @Deano478 

One way of doing this.

[BS_THE_ANALYST]

@Deano478 here's one way using the Summarize tool:

[Deano478]

WOW I appreciate all the responses guys I was really overthinking it I'll give all the various approaches a go as they may all be useful going forward