A
4/10/2019
190
A
4/11/2019
200
A
6/15/2019
195
A
6/16/2019
200
A
6/17/2019
200
B
7/2/2019
250
B
7/3/2019
295
C
5/15/5019
2000
Parse as a date
Sort by Date
Name - Ascending
dt - Ascending
Name
Trip
Int32
4
Empty
if todate(datetimeadd([row-1:dt],1,'day')) = [dt]
then [Row-1:Trip]
else [Row-1:Trip]+1 endif
Count consecutive days
if todate(datetimeadd([row-1:dt],1,'day')) = [dt]
then [Row-...
,
Horizontal
Days of Trip