Jobs done in-between 30 of each other

[AlexGavri]

Hello Community,

I have a workflow which pulls jobs with "Service Order" under a "Confirmed Date".

I need to see if we went to the same job in a span of 30 days.

I`m new with alteryx. Please help

Any ideas would be much appreciated.

[aatalai · Accepted solution]

@AlexGavri 

My understanding is that you want to know the duration of the job and whether it is more or less than 30 days (please let me know if this is different) 

I would start by using the summarising tool group by service order and then the min and max of confirmed date. This will give you the first and last day for each job in one row.

Then use the formula tool with the follwoing expression DateTimeDiff([EndDate], [StartDate], 'days') this will get you duration

And then create another forumla

with If [duration] (the newly generated field) <30 then "yes" else "no" endif

Let me know if that helps

You could be efficient and combine the formulas, but if you are starting out this would be easier to follow.