So what I have now from my search so far
Product Status Time
A Start 8.00 AM
A A1 8.05 AM
A A2 8.15 AM
A End 8.20 AM
Is there anyway I can get the duration (End - Start) = 20 minutes and then display as Duration for Product A as 20 minutes?
Try this run anywhere example
|makeresults |eval product="A"|eval status="Start A1 A2 End"|makemv status|mvexpand status
|appendcols [|makeresults|eval time="08:00 08:05 08:15 08:20"|makemv time|mvexpand time ]
|rename COMMENT as "Dummy data ends here"
|stats max(eval(if(status=="Start",time,null()))) as Start_Time,max(eval(if(status=="End",time,null()))) as End_Time by product
change stats to eventstats if you want to see all records in the result
View solution in original post
Thanks, it worked for me