I have two two columns of data, One is Expected box and another is Actual box. I would like to make Percentage/Average of how much actual Box values are missing compare with Expected box. Also some one my Actual boxes data there are no(which null/undefined) value. I would like to ignore those rows where Actual boxes are (null/undefined) which is compare with my Expected box. PS: I am beginner level splunker ? Is there any way I can do this Average based on requirements? This my search query: index::service sourcetype::service "order_tote_analytics" | spath "data.order_number" | search "data.order_number"=* | spath path=data{}.actual_totes{}.finalBoxAmount output=actualBox| spath path=data{}.estimated_totes{}.box output=estimatedBox | table estimatedBox actualBox This my table looks like PS: I would love to display that Percentage of actual values missing in single panel, It would nice to show me, how to do that? This is wrong search query 👇🏾👇🏾👇🏾 <panel>
<single>
<title>Percentage of actual values missing</title>
<search>
<query>index::service sourcetype::service "order_tote_analytics" | spath "data.order_number" | search "data.order_number"=$orderNumber$ | spath path=data{}.actual_totes{}.finalBoxAmount output=finalBox| spath path=data{}.estimated_totes{}.box output=estimatedBox | stats sum(estimatedBox) as totalBox, sum(finalBox) as finalbox</query>
<earliest>$chosenTimePeriod.earliest$</earliest>
<latest>$chosenTimePeriod.latest$</latest>
</search>
<option name="colorMode">block</option>
<option name="drilldown">none</option>
<option name="rangeColors">["0x53a051","0xf1813f","0xf8be34","0xf1813f","0xdc4e41"]</option>
<option name="refresh.display">progressbar</option>
<option name="useColors">1</option>
</single>
</panel>
<panel>
... View more