topic How to write a search to get a table of eventstats perc95 and avg by a certain field? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-to-write-a-search-to-get-a-table-of-eventstats-perc95-and/m-p/128892#M35024 <P>I need a table which gives me both perc95(response_time) and avg(response_time) by service_name<BR /> I am using the below query, but is giving me some weird results...</P> <PRE><CODE>index=jms_logs sourcetype=perflogs | eventstats perc95(response_time) as response_time_95p, avg(response_time) as avgRespTime | stats by service_name </CODE></PRE> <P>can someone please help me?<BR /> Thanks.</P> Mon, 28 Sep 2020 18:13:47 GMT edookati 2020-09-28T18:13:47Z How to write a search to get a table of eventstats perc95 and avg by a certain field? https://community.splunk.com/t5/Splunk-Search/How-to-write-a-search-to-get-a-table-of-eventstats-perc95-and/m-p/128892#M35024 <P>I need a table which gives me both perc95(response_time) and avg(response_time) by service_name<BR /> I am using the below query, but is giving me some weird results...</P> <PRE><CODE>index=jms_logs sourcetype=perflogs | eventstats perc95(response_time) as response_time_95p, avg(response_time) as avgRespTime | stats by service_name </CODE></PRE> <P>can someone please help me?<BR /> Thanks.</P> Mon, 28 Sep 2020 18:13:47 GMT https://community.splunk.com/t5/Splunk-Search/How-to-write-a-search-to-get-a-table-of-eventstats-perc95-and/m-p/128892#M35024 edookati 2020-09-28T18:13:47Z Re: How to write a search to get a table of eventstats perc95 and avg by a certain field? https://community.splunk.com/t5/Splunk-Search/How-to-write-a-search-to-get-a-table-of-eventstats-perc95-and/m-p/128893#M35025 <P>Try this</P> <PRE><CODE> index=jms_logs sourcetype=perflogs | stats perc95(response_time) as response_time_95p, avg(response_time) as avgRespTime by service_name </CODE></PRE> Thu, 20 Nov 2014 16:35:50 GMT https://community.splunk.com/t5/Splunk-Search/How-to-write-a-search-to-get-a-table-of-eventstats-perc95-and/m-p/128893#M35025 somesoni2 2014-11-20T16:35:50Z Re: How to write a search to get a table of eventstats perc95 and avg by a certain field? https://community.splunk.com/t5/Splunk-Search/How-to-write-a-search-to-get-a-table-of-eventstats-perc95-and/m-p/128894#M35026 <P>thanks. It worked just great.</P> Thu, 20 Nov 2014 16:44:47 GMT https://community.splunk.com/t5/Splunk-Search/How-to-write-a-search-to-get-a-table-of-eventstats-perc95-and/m-p/128894#M35026 edookati 2014-11-20T16:44:47Z