topic how to combine 2 panel results and sum of that result will display in 3rd panel in Splunk Dev

how to combine 2 panel results and sum of that result will display in 3rd panel

dall — Fri, 25 Sep 2020 11:26:58 GMT

hi team

Query 1(panel 1)

index=" " Message="*POWERING_ON*" host=" " | rex "(?<VMName>[^\/]+).vmx" | stats latest(host) as host, latest(_time) as time by VMName |eval time= strftime(time,"%d-%m-%Y %H:%M:%S")| stats count

query2(panel 2)

result=24

result=10

how i ll comine 2 query and get 1 panel with sum of 24+10=34

Re: how to combine 2 panel results and sum of that result will display in 3rd panel

richgalloway — Fri, 25 Sep 2020 12:42:10 GMT

You accepted an answer to a similar question yesterday. What's different here?

https://community.splunk.com/t5/Security-the-Enterprise/combine-2-query/m-p/521305#M36

Re: how to combine 2 panel results and sum of that result will display in 3rd panel

dall — Mon, 28 Sep 2020 03:27:41 GMT

here i want to add vm power on and off and i want to show total result

while adding only 2nd query result is showing