About WK

WK · ‎11-13-2023

Hi, Thanks for your response. My desired results: Item StartTime EndTime Duration A 02:05:00 02:15:00 00:10:00 B 02:15:05 02:25:05 00:10:00 B 02:40:05 02:45:05 00:05:00 I had tried similar methods like your but got wrong results. Fail duration should be calculated from first fail to first success. Thus actual record count should be 3 instead of 5. Sorting may not be the root cause for my question. It seems that if there are 2 "fail" events, "transaction" commands generates 2 overlapped records. B 02:20:05(fail) 02:25:05(success) 00:05:00 B 02:15:05(fail) 02:30:05(success) 00:15:00 Time duration of first one is included in second one. 02:30:05(success) should not be considered as the end of fail event. 02:25:05(success) is the correct one.

WK · ‎11-12-2023

Thanks for your swift response. I need to calculate the duration between first "fail" to first "success" for every Item. Unfortunately the result is incorrect: Item StartTime EndTime Duration B 02:40:05 02:45:05 00:05:00 B 02:20:05 02:25:05 00:05:00 B 02:15:05 02:30:05 00:15:00 ==> should be "B 02:15:05 02:25:05 00:10:00" A 02:10:00 02:15:00 00:05:00 A 02:05:00 02:20:00 00:15:00 ==> should be "A 02:05:00 02:15:00 00:10:00" I'd tried this method before, however consecutive "Result=fail" causes overlapped results.

WK · ‎11-12-2023

I have following data: 02:00:00 Item=A Result=success 02:00:05 Item=B Result=success 02:05:00 Item=A Result=fail 02:05:05 Item=B Result=success 02:10:00 Item=A Result=fail 02:10:05 Item=B Result=success 02:15:00 Item=A Result=success 02:15:05 Item=B Result=fail 02:20:00 Item=A Result=success 02:20:05 Item=B Result=fail 02:25:00 Item=A Result=success 02:25:05 Item=B Result=success 02:30:00 Item=A Result=success 02:30:05 Item=B Result=success 02:35:00 Item=A Result=success 02:35:05 Item=B Result=success 02:40:00 Item=A Result=success 02:40:05 Item=B Result=fail 02:45:00 Item=A Result=success 02:45:05 Item=B Result=success 02:50:00 Item=A Result=success 02:50:05 Item=B Result=success 02:55:00 Item=A Result=success 02:55:05 Item=B Result=success My desired results: Item StartTime EndTime Duration A 02:05:00 02:15:00 00:10:00 B 02:15:05 02:25:05 00:10:00 B 02:40:05 02:45:05 00:05:00 I had tried transaction and streamstats but got wrong results. Can anybody here help me to solve this problem? Thank you.

Posts	3
Solutions	0
Karma Given	0
Karma Received	0
Member Since	‎11-12-2023

Online Status	Offline
Date Last Visited	‎11-14-2023 05:31 PM

How to calculate individual fail time?

Re: How to calculated individual fail time?

Re: How to calculated individual fail time?

How to calculate individual fail time?