Tags for sequential
Uniquely identify sets of sequential values
Hello, I'm trying to add a column the table below that is a unique identifier of sequential dates.  Stand alone dates would also have a unique identifier.  I've been able to get as far as seeing if a row is part of a 2+ day streak using coalesce, over() and preceding/following... but can't think of a way to tell the streaks apart.
unique identifier sequential