Basically, I have a problem in which I want to run two queries the first query will return me the total number of requests and the second query will return requests that fail so that i can calculate the percentage but I am unable to do this with a subquery.   Currently, I am using this query   "Carrier Failure: provider_name=*" | dedup application_id | stats count AS total_carrier_errors | append [search host="prod-celery-gateway-0*" sourcetype="supervisor" "driver dispatch_request: Sending request to" NOT failed | stats count AS total_requests] | table total_carrier_errors total_requests | eval carrier_errors_percent=(total_carrier_errors/total_requests*100) Can anyone guide me with this? Thank You! ... View more