I need to generate a report where it will output table with different timings in columns. Trick part is logs captured fall under a unique transaction ID index=<app> "Start Time" OR "End Time" Sample Output Log (Note that this is under 1 transaction ID): 8:00 TransID "Start Time" 8:01 TransID "End Time" 8:30 TransID "Start Time" 8:31 TransID "End Time" 9:00 TransID "Start Time" 9:01 TransID "End Time" Table should look like: TransID StartTime1 EndTime1 Duration1 StartTime2 EndTime2 Duration 2 StartTime3 EndTime3 Duration3 0123 8:00 8:01 1:00 8:30 8:31 1:00 9:00 9:01 1:00
... View more