Awesome Brad - glad to hear you were able to find a solution.  Thanks for letting me know!

Toby

Thanks for the response.
Fun fact, I recently discovered the power of AI.
I copied the filtered log lines out of LVP and pasted them into Microsoft CoPilot and asked it to generate a report for me.
It give me python and it worked like a charm. I even got it to tweak the report format.
I was amazed.

Hi Brad,

LogViewPlus SQL currently does not support WITH or LAG statements.  I don't think this scenario will be possible without at least one of these constructs.

It's a good use case and I think it is something that LogViewPlus should be able to do.  I will have a think and see if we can come up with a solution in a future release.

In the meantime, the best I can suggest is to export the rows to a CSV file and then using Excel to perform the necessary calculations.

Thanks,

Toby

I have a log where I have filtered out pairs of log lines.
Firstly the log line where an API request is sent and secondly the log line where the API response is received.
I want to see a timeline bar graph that shows the API responsiveness over a period so I can compare today versus 3 days ago (or another reference) to monitor for performance issues.

I just can't find examples that do this. 
Can you please help?

Sample log line pair is below
I have a parser so I have columns for date and time as well as turning on the elapsed column, I just need the query to report on the elapsed values

2024-11-07 06:43:03.956 I/app(722): [activity] [api  ] - } to https://url.com/endpoint.svc/endpoint
2024-11-07 06:43:04.345 I/app(722): [activity] [api  ] - } from https://url.com/endpoint.svc/endpoint