time chart / stats for each type of request and time in log file.

[vamsi199]

Hi All,

I have a weird log file which I have parsed using regex to extract fields.(attached screenshot).

Now I want to get

1) time chart/stats for each type request with an average of duration.

2) line chart over time for each request id for all corresponding requests of request id][1].

Thanks,

[somesoni2]

Try like this

1) time chart/stats for each type request with an average of duration.

your current search till rex command..do not include your table command...
| convert dur2sec(duration) | eval duration=if(isnull(duration),strptime(duration,"%H:%M:%S:%N")-relative_time(now(),"@d")
| timechart avg(duration) by name limit=0

2) line chart over time for each request id for all corresponding requests of request id

your current search till rex command..do not include your table command...
| convert dur2sec(duration) | eval duration=if(isnull(duration),strptime(duration,"%H:%M:%S:%N")-relative_time(now(),"@d")
| timechart avg(duration) by operationid limit=0