Sorting and Assigning Record ID

[oliviagabriele]

Data is regarding candidates and jobs applied to
EXAMPLE of data

Job Requisition	Candidate	Applied Date	Final Recruiting Stage
JOB1234	John Smith	1/1/2025	Interview
JOB1234	Amy Lee	1/4/2025	Offer
JOB4567	Bob Jones	1/2/2025	Offer
JOB4567	Debra Brown	1/6/2025	Interview
JOB8910	Jane Doe	1/1/2025	Offer
JOB8910	John Deere	1/2/2025	Offer

There are 10 Job Requisitions, with thousands of applicants and what I'm trying to show is that candidates who are last to apply are still moved forward at the same rates as candidates who apply first (final recruiting stage).

When I did this for just one job requisition, I simply sorted  by Applied Date then assigned a Record ID to rank.

However, when using multiple job requisitions, the applied dates are all over the place since these jobs are all posted at varying days/months.

What's the best way to assign an application ranking to the candidates for their respective Job Requisition, where I can later show count of Offers, Interviews by the first half of applicants, and the second half of applicants?

Is this possible?

[abacon · Accepted solution]

@oliviagabriele Is this what you are looking for? Are you on alteryx 2024.2 or later? If so, the record ID tool has a grouping option that allows you to group your record IDs on a specific column - in this case the Job Req field.

If you are on an older version, it's a little trickier but still doable. You will need to use a multi-row formula to check if the record above the current one is the same job req, if so, add 1 to the record ID - if not, restart at 1.

Bacon

[abacon]

@oliviagabriele If this worked for you, please mark it as the solution so others may find it faster.

Bacon

[dreldrel]

I think @abacon's idea shall be able to achieve your request. If you want to count offers and interviews. You can simply use a summarize tool

[oliviagabriele]

This was helpful, thank you!!