CountIF Function on Alteryx

Oliverharkj

Hi there,

Apologies if this has already been asked as I am very new to Alteryx. 

I am trying to produce a CountIF on a larger data set but it is essentially the same as in the screenshots. 

I have filtered my data and removed null values just struggling to do the count.

Thank you so much in advance.

Capture2.PNG

Capture1.PNG

TheOC

Hey @Oliverharkj 
You will want to use the count function within the summarize tool:

If you still want the same number of records - you can use the join tool, please see attached.

Oliverharkj.yxmd