topic How do I perform math against two searches? in Splunk Search

How do I perform math against two searches?

mo86 — Thu, 30 Aug 2018 14:01:12 GMT

I have two searches that use the same index and each return a numerical total, differing only in the period of time of the data they look at. How would I perform math on the search results for example adding or calculating percentages?

Re: How do I perform math against two searches?

inventsekar — Thu, 30 Aug 2018 14:54:57 GMT

maybe, could you write the 2 queries please..

Re: How do I perform math against two searches?

mo86 — Thu, 30 Aug 2018 14:57:53 GMT

index=data NOT ID="" earliest=-1d@d latest=-0d@d | regex name!="[a-z]."| dedup id | stats count

index=data NOT ID="" earliest=-0d@d latest=now | regex name!="[a-z]."| dedup id | stats count

Re: How do I perform math against two searches?

inventsekar — Thu, 30 Aug 2018 15:12:21 GMT

| makeresults
| fields - _time
| eval Total1=[search index=data NOT ID="" earliest=-1d@d latest=-0d@d | regex name!="[a-z]."| dedup id | stats count | return $count] 
| eval Total2=[search index=data NOT ID="" earliest=-0d@d latest=now | regex name!="[a-z]."| dedup id | stats count | return $count]
| eval FullTotal=Total1+Total2 | eval percentage=((Total1/FullTotal)*100)

Re: How do I perform math against two searches?

mo86 — Thu, 30 Aug 2018 15:25:33 GMT

Thank you, that works great!