Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

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
Top Solution Authors