Calcualation

[aparna0208]

Hi,

I have a dataset that includes the day and duration that a process was run. On the same day it would have run multiple times and logged the duration. Wanted to know if there is a way to identify the two earliest run from each day? Thanks in advance

WF day        Duration

Mon              05:54:00

Mon              05:59:00

Mon               06:13:00
Tue                06:25:00

Tue                06:26:00

Tue                 12:04:00

Tue                 13:55:00

[apathetichell]

is duration stored in a time?

sort wf day and duration

sample choose the first 2. group by wf day. like the attached workflow...

[Qiu]

@aparna0208 
If we stick to the word "Calculation"

[apathetichell]

@QiuI like it! I think you can use: datetimediff([3],"00:00:00","seconds") where [3] is your time column and get the same result - no?

[Qiu]

@apathetichell 

Thank you for the advice. It is simplier.