You have a desire to "combine" three conditions (which is very vague), and you have a query.  So, where is the question?  How can others help if we don't know whether that query gives you what you need?  If the query does not meet your requirement, what is the requirement? Just to point out: Your query suggests three conditions in AND relationship, whereas the opening statements seem to suggest an OR relationship.  Another problem with the illustrated code is that after performing | where ABCJobCount<1, the second | count by JobName is not necessarily XYZJobCount as your code seems to assume. If the three conditions are in OR relationship, simply do index="xyz" sourcetype=xyz ("abc reminder" OR "xyz reminder" OR "123 reminder") earliest=-24h | eval JobName=case( searchmatch("abc reminder"), "ABC reminder", searchmatch("xyz reminder"), "XYZ reminder", searchmatch("123 reminder"), "123 reminder") | stats count by JobName | where JobName == "ABC reminder" AND count < 1 OR JobName == "XYZ reminder" AND count < 5 OR JobName == "123 reminder" AND count < 22 Hope this helps.   ... View more