https://community.splunk.com/t5/Splunk-Search/splunk-query-with-if-condition/m-p/554103#M157306 <P>Hi</P><P>check stats + eval from this page&nbsp;<A href="https://docs.splunk.com/Documentation/Splunk/8.2.0/SearchReference/Stats" target="_blank">https://docs.splunk.com/Documentation/Splunk/8.2.0/SearchReference/Stats</A></P><P>I think that this is your solution.</P><P>r. Ismo</P> Wed, 02 Jun 2021 14:15:52 GMT isoutamo 2021-06-02T14:15:52Z https://community.splunk.com/t5/Splunk-Search/splunk-query-with-if-condition/m-p/554101#M157305 <P>Hi Team<BR /><BR />i want to display the success and failure count for that i have only one field i.e<BR /><BR />b_failed="false"<BR /><BR />using this i could get the success count how can i get the count of jobs that are failed&nbsp;<BR /><BR />Below is the query and it doesnt return the failure count<BR /><BR />....|eval status=if(b_failed="false","success","failed")<BR />&nbsp; &nbsp; |stats count(status) as count<BR /><BR />can someone please correct me<BR />Thanks</P> Wed, 02 Jun 2021 14:04:18 GMT https://community.splunk.com/t5/Splunk-Search/splunk-query-with-if-condition/m-p/554101#M157305 Nith1 2021-06-02T14:04:18Z https://community.splunk.com/t5/Splunk-Search/splunk-query-with-if-condition/m-p/554103#M157306 <P>Hi</P><P>check stats + eval from this page&nbsp;<A href="https://docs.splunk.com/Documentation/Splunk/8.2.0/SearchReference/Stats" target="_blank">https://docs.splunk.com/Documentation/Splunk/8.2.0/SearchReference/Stats</A></P><P>I think that this is your solution.</P><P>r. Ismo</P> Wed, 02 Jun 2021 14:15:52 GMT https://community.splunk.com/t5/Splunk-Search/splunk-query-with-if-condition/m-p/554103#M157306 isoutamo 2021-06-02T14:15:52Z https://community.splunk.com/t5/Splunk-Search/splunk-query-with-if-condition/m-p/554104#M157307 <P>Try this</P><LI-CODE lang="markup">|stats sum(eval(if(b_failed="false",1,0))) as success_count, sum(eval(if(b_failed="false",0,1))) as failed_count</LI-CODE> Wed, 02 Jun 2021 14:17:51 GMT https://community.splunk.com/t5/Splunk-Search/splunk-query-with-if-condition/m-p/554104#M157307 harsmarvania57 2021-06-02T14:17:51Z