Contractor Conversions to Employees Calculation

Below I have a sample explanation of my data. I'm looking to see how many contractors converted to employees week over week. I figured out the formula in excel, but I had to create 3 different columns to find the answer. Below are the details and question. If anyone could help me figure this out I would greatly appreciate it

Datasets

Transformation

Accepted answers

JosephSerpis

Hi @JonaV this problem won't be solved with a single formula tool in Alteryx. Firstly the Alteryx formula tool does not have a countif function as fundamentally the formula tool works at a single row at a time. So unlike excel you can't have a formula for a range then extends beyond the current row. This is why thus far I have used multi row tools and other data preparation steps. I have mocked up a workflow that mirrors your logic that you provided in your excel however you can see I have taken a number of steps and not just used one tool to achieve this.

Conversion_01052020.yxmd

All comments

JosephSerpis

Hi @JonaV I mocked up a workflow let me know what you think?

Contractor_Conversion_01052020.yxmd

JonaV

@JosephSerpis I don't think the way the multi row formula is set up here works, especially with the row+1 in the expression. My data is not sorted in any order, so i doubt using the row+1 will work. In reality, I have about 105k+ rows of data with the ID's spread out in no specific order. I set it up that way in the sample in the picture I attached just as an example.

I've never used the multi row formula before since I'm fairly new to Alteryx. I've just been able to understand it quicker because I have background knowledge of databases and working with Excel

If there is another way to figure this out and/or need other pieces of information, please let me know

Thanks

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703