topic Re: Creating a Dashboard based on a query. in Dashboards & Visualizations

How to create a graph of these results showing a graduation or reduction of the response times?

sheldonjolly — Tue, 08 Mar 2022 04:58:52 GMT

I have a query based on response times from a service.

index=homebanking "/soa/mcoi-rc-services/ContractService" Time="*" | rex field=_raw "\/(?<time>[^_\/]+)[\w\.]+($|\s)" | stats count by Time | fields - count

I get these results......

I'd like to now create a graph of these results showing a graduation or reduction of the response times.

Can someone help?

Best,

Sheldon.

Re: Creating a Dashboard based on a query.

richgalloway — Mon, 07 Mar 2022 16:03:30 GMT

After running the search, click on the Visualization tab and select the visualization that best presents the data.

Re: Creating a Dashboard based on a query.

somesoni2 — Mon, 07 Mar 2022 20:37:47 GMT

Try something like this

index=homebanking "/soa/mcoi-rc-services/ContractService" Time="*" | rex field=_raw "\/(?<time>[^_\/]+)[\w\.]+($|\s)" | timechart avg(Time) as Avg_Response_Time

Re: How to create a graph of these results showing a graduation or reduction of the response times?

sheldonjolly — Tue, 08 Mar 2022 06:46:31 GMT

This worked quite nicely. Many thanks.

Now, how do I convert the response time to seconds?