https://community.splunk.com/t5/Splunk-Search/How-to-calculate-average-of-response-time-in-seconds/m-p/565737#M197126 <P>Thanks&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/231884">@PickleRick</a>&nbsp;</P><P>Then the average of my response time is calculating in seconds right?</P><P>&nbsp;</P><P>Regards,</P><P>Madhu R</P> Fri, 03 Sep 2021 04:36:39 GMT Madhusri 2021-09-03T04:36:39Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-average-of-response-time-in-seconds/m-p/565735#M197124 <P>Hi,</P><P>I need to calculate average of response time in seconds for my application.</P><P>&nbsp;</P><P>Query i am using</P><P>index="prod*_ping*"&nbsp; source="*splunk-audit.log" "event=SSO" connectionid=*<BR />| stats avg(responsetime) as AvgRespTimeInSec by connectionid</P><P>In connectionid i will get the application details</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Madhusri_0-1630643120981.png" style="width: 400px;"><img src="https://community.splunk.com/t5/image/serverpage/image-id/15819iF5514BF6ECC9D04C/image-size/medium?v=v2&amp;px=400" role="button" title="Madhusri_0-1630643120981.png" alt="Madhusri_0-1630643120981.png" /></span></P><P>Please let me know whether my query is correct for calculating the average of response time in seconds?</P><P>&nbsp;</P><P>Regards,</P><P>Madhusri R</P><P>&nbsp;</P><P>&nbsp;</P> Fri, 03 Sep 2021 04:28:45 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-average-of-response-time-in-seconds/m-p/565735#M197124 Madhusri 2021-09-03T04:28:45Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-average-of-response-time-in-seconds/m-p/565736#M197125 <P>Of course it depends on your data whether it makes sense or not but in general, | stats avg(field) is indeed the way to calculate average of field values.</P> Fri, 03 Sep 2021 04:34:09 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-average-of-response-time-in-seconds/m-p/565736#M197125 PickleRick 2021-09-03T04:34:09Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-average-of-response-time-in-seconds/m-p/565737#M197126 <P>Thanks&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/231884">@PickleRick</a>&nbsp;</P><P>Then the average of my response time is calculating in seconds right?</P><P>&nbsp;</P><P>Regards,</P><P>Madhu R</P> Fri, 03 Sep 2021 04:36:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-average-of-response-time-in-seconds/m-p/565737#M197126 Madhusri 2021-09-03T04:36:39Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-average-of-response-time-in-seconds/m-p/565740#M197129 <P>Depends on your source data. If the field itself is measured in seconds then the average of the values in that field will be also in seconds.</P><P>Otherwise you might want to use eval to multiply or divide the value to other unit.</P> Fri, 03 Sep 2021 04:47:28 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-average-of-response-time-in-seconds/m-p/565740#M197129 PickleRick 2021-09-03T04:47:28Z