Forum Discussion
kenblack
6 years agoHelper I
desktop
I have 2 columns start and stop I want to count the number of start stop events according to the following rules counting starts when first discharge occurs • any start in the first 12 hou...
amitchandak
6 years agoSuper User
kenblack , You can get diff with min date time of block and use that to get id
diff with min date time block
new col= datediff( minx(filter(Table, [block] =earlier([block]) ),[date time]),[date time],hours)