Hi @summer_le , since you know how to calculate difference, I will not look into that part, but only how to get start and end of time. One way to do this is as follows:
- Identify which rows are reads and writes into a column. This can be done via Rule Engine:
$Record$ LIKE "Read*" => "Read"
$Record$ LIKE "Write*" => "Write"
And say I write this result to a new column called “Type”:
- Now just group by Code and Type, and retrieve minimum and maximum of Time:
Something like this will do:
Here’s the workflow: Get min and max Time of Read and Write per Code.knwf (18.0 KB)