It is something like this: 3/12: Log1: Processing decryptedRecord:{"account":"mainAccount1","EventType":"start"} Log2: Processing decryptedRecord:{"account":"mainAccount1","EventType":"stop"} Log3: Processing decryptedRecord:{"account":"mainAccount1","EventType":"start"} Log4: Processing decryptedRecord:{"account":"mainAccount1","EventType":"stop"} Log5: Processing decryptedRecord:{"account":"mainAccount1","EventType":"stop"} 4/12: Log1: Processing decryptedRecord:{"account":"mainAccount1","EventType":"start"} Log2: Processing decryptedRecord:{"account":"mainAccount1","EventType":"stop"} Log3: Processing decryptedRecord:{"account":"mainAccount1","EventType":"start"} my expected output: | Date| account| Event| count| | 3/12|mainAccount1| flap | 2| |4/12| mainAccount1| flap | 1| where 1 flap is the jump between consequitive start-stop
... View more