Average output of 3 panels in one panel

[kumargaurav11]

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.

[inventsekar]

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

[to4kawa]

<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>

[to4kawa]

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

try token.

[kumargaurav11]

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