Identify Re-Attenders Within A Set Period of Time

[AlexSpencer]

Hi All

Please can you help?

We are looking to identify when somebody re-usses our service within a set period of time (24 hours/48 hours etc.). Each person has a unique identifier and an active date/time. For example from the below it would identify that Member of Public #3 re-used the service within 48 hours, whereas nobody else did in the below table: 

Member of Public	Active Date/Time
1	01/10/2022 08:00
2	01/10/2022 08:30
3	03/10/2022 09:00
4	06/10/2022 09:30
3	04/10/2022 09:30
5	05/10/2022 09:30
2	07/10/2022 09:30
1	04/10/2022 09:30

Thank you in advance for all your help.

Alex Spencer

[amitchandak · Accepted solution]

@AlexSpencer , one is you can diff in hours with next date

new column =

var _min = minx(filter(Table, [Member of Public] = earlier([Member of Public]) && [Active Date/Time] > earlier([Active Date/Time])),[Active Date/Time])

return

datediff([Active Date/Time], _min, hour)

You can use this column to 24/48 hour repeat