Countif formula in Alteryx

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!

Sample data.xlsx

Developer Tools

Custom Tools

Accepted answers

ponraj

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

Countif formula in Alteryx.yxmd

danrh

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.

solution.yxmd

danrh

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

solution (1).yxmd

danrh

Attached are two different approaches you could take. The first is dynamic, in case the names of your columns change or you have more/fewer benchmarks. If they're always going to be the same benchmarks, the second is a lot simpler. Take a look, see what you think. Note that the Select and Select Records tools at the beginning are just to put it into a usable format --- you may not need them, depending on how your data looks already.

solution.yxmd

All comments

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

Quick Links

Unanswered
Community Events
Groups

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335