Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Countif Formula to Alteryx

senzuki123
7 - Meteor

Hi All,

 

I would like to have an workflow for this. Thanks in Advance

 

Untitled.png

7 REPLIES 7
senzuki123
7 - Meteor

Need help for this. ASAP. Thanks in Advance

 

bharti_dalal
10 - Fireball
senzuki123
7 - Meteor

Hi @Bharti,

 

I want the same output aswell ? Will you recommend any links or workflow with same output

 

Thanks,

bharti_dalal
10 - Fireball

hi @senzuki123,

 

That link provide you the method of how to solve the problem. if you want exactly same what you need, please provide sample data sheet and i can give you solution. Thanks

danrh
13 - Pulsar

Hey @senzuki123,

 

In this kind of situation I usually suggest using a Summarize tool to aggregate the data (in this case, getting a count by RECORD ID), performing the calculation, and then using a Join to re-apply it to your dataset.  Something like:

image.png

 

Note that in the attached, I've added dummy data, rather than trying to replicate yours :)

 

Hope it helps!

senzuki123
7 - Meteor

Thank you so much @darnh,

Phavaldar
6 - Meteoroid

Thank you so much. You solution helped me to solve my problem. I am getting the result in a way i want. Thanks

Labels