We’re rewarding the question askers & reputations are being recalculated! Read more.

New answers tagged


A common way of doing this is to compare the total order (regarding date) vs the relative order within each value, let's call the difference grp. If the grp changes, it means that date from another partition of value interfered with the current group. So by picking the min date for each value, grp we can achieve what you want. I'll leave days_at_this_val as ...

Top 50 recent answers are included