https://community.splunk.com/t5/Splunk-Search/Min-and-Max-Response-Time/m-p/536214#M151612 <P>You can calculate the numbers then delete them if the status is not success.</P><LI-CODE lang="markup">... | stats min(ResponseTime) as Min_Response_Time, max(ResponseTime) as Max_Response_Time by MicroService | eval Min_Response_Time=if(Status=0,null,Min_Response_Time), Max_Response_Time=if(Status=0,null, Max_Response_Time)</LI-CODE> Mon, 18 Jan 2021 13:51:44 GMT richgalloway 2021-01-18T13:51:44Z https://community.splunk.com/t5/Splunk-Search/Min-and-Max-Response-Time/m-p/536202#M151606 <P>Hi I want to calculate<STRONG> Min and Max Response time</STRONG> only if the <STRONG>status is success.<BR /><BR /></STRONG>Below is the table format:<BR /><BR /><BR /></P><TABLE width="851"><TBODY><TR><TD width="98">MicroService</TD><TD width="137">Total_Transaction</TD><TD width="64">Success</TD><TD width="64">Failure</TD><TD width="64">Avg</TD><TD width="64">Failure%</TD><TD width="64">Success%</TD><TD width="146">Min_Response_Time</TD><TD width="150">Max_Response_time</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>LostStolenCard</TD><TD>7</TD><TD>5</TD><TD>2</TD><TD>5223</TD><TD>28.57</TD><TD>71.43</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>CreditLimit</TD><TD>15</TD><TD>0</TD><TD>15</TD><TD>4324</TD><TD>0</TD><TD>100</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Mon, 18 Jan 2021 13:42:06 GMT https://community.splunk.com/t5/Splunk-Search/Min-and-Max-Response-Time/m-p/536202#M151606 rj1408 2021-01-18T13:42:06Z https://community.splunk.com/t5/Splunk-Search/Min-and-Max-Response-Time/m-p/536211#M151610 <LI-CODE lang="markup">| eval successTime = if(staus="Success", responseTime, null) | stats max(successTime) as Max_Response_time min(successTime) as Min_Response_Time by MicroService</LI-CODE> Mon, 18 Jan 2021 13:42:39 GMT https://community.splunk.com/t5/Splunk-Search/Min-and-Max-Response-Time/m-p/536211#M151610 ITWhisperer 2021-01-18T13:42:39Z https://community.splunk.com/t5/Splunk-Search/Min-and-Max-Response-Time/m-p/536214#M151612 <P>You can calculate the numbers then delete them if the status is not success.</P><LI-CODE lang="markup">... | stats min(ResponseTime) as Min_Response_Time, max(ResponseTime) as Max_Response_Time by MicroService | eval Min_Response_Time=if(Status=0,null,Min_Response_Time), Max_Response_Time=if(Status=0,null, Max_Response_Time)</LI-CODE> Mon, 18 Jan 2021 13:51:44 GMT https://community.splunk.com/t5/Splunk-Search/Min-and-Max-Response-Time/m-p/536214#M151612 richgalloway 2021-01-18T13:51:44Z https://community.splunk.com/t5/Splunk-Search/Min-and-Max-Response-Time/m-p/536220#M151613 <P>Thanks!<BR /><BR />Can u help me with this one-&nbsp;<BR /><A href="https://community.splunk.com/t5/Splunk-Search/90th-percentile/m-p/534296#M150983" target="_blank">https://community.splunk.com/t5/Splunk-Search/90th-percentile/m-p/534296#M150983</A></P> Mon, 18 Jan 2021 14:35:32 GMT https://community.splunk.com/t5/Splunk-Search/Min-and-Max-Response-Time/m-p/536220#M151613 rj1408 2021-01-18T14:35:32Z