Countif formula in Alteryx

[lokeshramamurthy]

Hi,

I am trying to build countif condition on alteryx but unfortunately am unable to find the logic. 
Request anyone to help me build the same on Alteryx.

I am looking to find "The number of Zero counts in 1 year" from an excel raw data sheet. Could anyone advise or build an sample work flow for the same.

I will share the raw data for which i would require The number of Zero counts in 1 year from the raw data which am sharing. 

Note:- I have also done the calculation on excel. Referring the same calculation i am trying replicate the same logic on alteryx. Please help!

[MarqueeCrew]

One way to solve this is to use a filter to find the year 1 zero records and then use a count records tool. That value can be added to the original data as a new column through the use of an append tool.

Cheers,

Mark

[lokeshramamurthy]

Hi Mark, 

Thanks, It would be great if you could help me with an built module. 

Regards,

Lokesh

[ponraj]

Formulas there are on your sample data not working.  Can you correct it and then share sample data?

[lokeshramamurthy]

Hi, 

Apologies. Please find the revised data attached.

Regards,

Lokesh

[ponraj · Accepted solution]

Here is the sample workflow for your case.  As far as I know, there is no direct formula to bring the result you are looking for.  However, result can be achieved using couple of tool in alteryx. Hope this is helpful. 

workflow

[lokeshramamurthy]

Hi,

Thanks for your time. The workflow built for my requirement is not getting me the required output. I am looking for an exact output shared on excel and where the zero counts for 1year should arrive in one column.

Regards,

Lokesh 

[danrh · Accepted solution]

Slightly different than @ponraj's solution to fit requirements, but the idea is the same:

Take a look, see if it works for your case.

[lokeshramamurthy]

Hi Both,

Thanks for the solution. The Module shared was very useful and now I would like to build another function called "SMALL". 

I will share the sample data for which I want an built in module solution. 

I am looking for an "Min of selected SKU in last 1 Years" in the sample data which I am sharing now.

[danrh · Accepted solution]

Check out the attached, it should handle both the zero records and the min.