Dev Space

Customize & extend the power of Alteryx. SDKs, APIs, custom tools, and more!
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

How do I count individual occurrence of a string by string in another column?

Highlighted
5 - Atom

I am using Alteryx 2018.

 

I would like to count how many individuals in a department have missed work by day.  So in department 88 3 employees missed on date xx/xx/xx, in department 52 1 employee missed on same date, in department 35 5 employees missed on same date, etc until I have a result for the year of department # of Employees gone and date.  Workflow is attached and the main data is in the top flow up the the UNION tool.  I will need to merge the two flows together at some point but I may be doing it to soon.  I just know that the data for what I am requesting is the data from the top work flow.

 

Thank you

 

Jen

Highlighted
7 - Meteor

@jschoenh what you attached does not have the source data.  If you go to the Options menu and Export it will wrap the project into a yxzp

 

BetterFerret_0-1578952490237.png

 

If you attach that it will be easier to solve your problem.

5 - Atom
Thank you, this is my first time so I appreciate the advice. Here is the exported file.



Jennifer J. Schoenherr
Highlighted
7 - Meteor

@jschoenh doesn't appear that the attachment uploaded.