Forum Discussion
kenblack
Helper I
Helper Idesktop
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
Super User
Super Userkenblack , 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)