Can you identify trends between 2 date ranges?

[MS0121]

Hi All,

I am currently looking through a clients sickness data to identify trends and patterns per an employee. 

I have added dummy data below and pretty much I am wondering if there a tool(s) in Alteryx which can identify trends per an employee name?

For example, on the dummy data below we can see John Smith has been taking off the first 14 days for 3 months in a row and has an identical reason for each one. 

Dave Ruby below, seems to be taking off a specific Thursday each month and for the same reason. 

Is there a way to do this automatically within Alteryx for 500 rows of data? I can see how it can be done within Excel but of course, Alteryx would be easier. 

Employee Name	Sickness Date	Sickness Date Work Day	Return Date	Return Date Work Day	Sickness Reason
John Smith	01/01/2022	Monday	14/01/2022	Monday	Headache
John Smith	01/02/2022	Monday	14/02/2022	Monday	Headache
John Smith	01/03/2022	Monday	14/03/2022	Monday	Headache & Fever
Dave ruby	23/06/2022	Thursday	24/06/2022	Friday	Covid
Dave ruby	23/07/2022	Thursday	24/07/2022	Friday	Covid
Dave ruby	23/08/2022	Thursday	23/08/2022	Friday	Covid

Thanks for your time and help. 

[Sarreddy]

@MS0121 

Is it expected output like this.

Ajith

[MS0121]

Hey, thanks for the response and help. 

I was after something like:

There is a trend where David Ruby takes off the 3rd Thursday of each month and the reason is Covid. With the results data formatted. 

Guess if there isn't a way to do it, I can do it via countifs in Excel?

[KrishnaChithrathil]

@MS0121 

Can you provide us a sample output, please?

[MS0121]

Just something to:

Finds a pattern on days. E.g. is there a certain day or date an employee is taking off sick? This would count as a trend/pattern which needs to be looked into further.

Is there a pattern with a sickness reason per employee? something else to look out. Can probably use the summarise tool for this.

Overall, looking for something to find the trends for me. I guess something like Benfords law but for this type of data