topic Re: Average output of 3 panels in one panel in Dashboards & Visualizations

Average output of 3 panels in one panel

kumargaurav11 — Sat, 17 Oct 2020 01:44:07 GMT

I have 3 panels with single values in a dashboard.
Example :
Panel A : 15HRS
Panel B : 3 HRS
Panel C : 4 HRS

I want average of all 3 in one panel say Panel D= avg(Panel A,B,C).
Since searches in panel A,B & C are different and having different sourcetype/indexes so don't want to merge all the searches in one.

Re: Average output of 3 panels in one panel

to4kawa — Sat, 17 Oct 2020 01:49:42 GMT

https://docs.splunk.com/Documentation/Splunk/8.0.6/Viz/tokens

try token.

Re: Average output of 3 panels in one panel

kumargaurav11 — Sat, 17 Oct 2020 01:59:13 GMT

@to4kawa - Could you please help with a sample query or some specific examples.

Re: Average output of 3 panels in one panel

to4kawa — Sat, 17 Oct 2020 02:28:19 GMT

<dashboard> <label>sample1</label> <row> <panel> <single> <search> <query>| makeresults | eval result="1"</query> <earliest>-24h@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> <done> <set token="search1">$result.result$</set> </done> </search> <option name="drilldown">none</option> </single> </panel> <panel> <single> <search> <query>| makeresults | eval result="2"</query> <earliest>-24h@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> <done> <set token="search2">$result.result$</set> </done> </search> <option name="drilldown">none</option> </single> </panel> <panel> <single> <search> <query>| makeresults | eval result="3"</query> <earliest>-24h@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> <done> <set token="search3">$result.result$</set> </done> </search> <option name="drilldown">none</option> </single> </panel> </row> <row> <panel> <single> <search> <query>| makeresults | eval average=round(($search1$+$search2$+$search3$)/3,1)</query> <earliest>-24h@h</earliest> <latest>now</latest> <sampleRatio>1</sampleRatio> </search> <option name="drilldown">none</option> </single> </panel> </row> </dashboard>

Re: Average output of 3 panels in one panel

inventsekar — Sat, 17 Oct 2020 03:13:27 GMT

@kumargaurav11 ...as your query is resolved, please accept @to4kawa 's answer as solution. thanks and karma points appreciated!