Group by date and calculate difference between these groups.

[vlad_kutateladze]

Hi, 

I have data in following format: Name and Date of visiting location by tourist. I need to group visits with difference between less than 30 days in one trip and calculate difference between trips. I tried with Cross tab and Transpose , to make Date of visiting as horizontal columns to put after formulas,  but problem is that in real datasets number of visits can be sometimes more than 100.   Thank you. 

My input 

Need output something like this 

[Thableaus · Accepted solution]

Hi @vlad_kutateladze 

Does something like this (attached) work well for you?

Cheers,

[BrandonB · Accepted solution]

I think that this should do the trick for you! Workflow is attached. 

 

[BrandonB]

Very elegant solution @Thableaus! 

[vlad_kutateladze]

@Thableaus @BrandonB Thank you so much!