I am trying to group data in row_id order, but regular grouping skips over dates. I'm trying to accomplish the below, but have been failing miserably. I've tried partitioning, lead lag, etc. Continue reading...