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,
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