Forum Discussion
Finding Consecutive Records - Weekly Buckets
Hi All, Trying to find a way to identify users that have logged in for x consecutive weeks. Sample data below: Date UserID 22-01-20 ABC 29-01-20 ABC 05-02-20 ABC 12-02-20 ...
Thanks for the reply.
What does the Week / Date table look like? Do I simply have the dates and then the WEEKNUM()? If this is the case, will this work if the data spans over 52 weeks, so multiple identical WEEKNUM() values?