Hi,
I am working on a dashboard. i am creating a table to monitor the count, average response time and maximum response time of the Api calls.
I need some assistance with the rex field
here is my logger:
2019-08-20 10:37:02,690 INFO package name [header-values] [METRICS] Response Time for POST /service url: 1658 ms, httpResponseCode=200
here is my search query
source="/log/server.log"
/api1
OR /api2
OR /api3
"[METRICS] Response Time"
| rex field=_raw " (?<Request>/.*):"
| rex field=_raw "(?<Time>.*?)ms"
| stats count as Total,
avg(Time) as "Average Response Time (ms)",
max(Time) as "Maximum Response Time (ms)" by Request
The table is generating but only the count is working. please assist with rex field to get the average response time
Expected result
Request Count Average response time Maximum response time
/api1 1 ms ms
/api2 1 ms ms
Thanks in advance !!
... View more