I'm trying to optimize my queries in my dashboard using base searches, but I'm having a bit of trouble.
I have two base searches which are reusable, but I'm not sure how to incorporate it into my dashboard
<search id="First_Base_Search">
<query>index=Auto log!=null location=farm</query>
</search>
<search id="Second_Base_Search">
<query>rename growTime as Duration | stats perc50(totalTimes) as s50, perc90(totalTimes) as s90 by Duration | table Duration, s50, s90 | untable Duration, percentile, value | chart first(value) over Duration by percentile</query>
</search>
Dashboard:
<dashboard>
<label>Perf Tests</label>
<row>
<panel>
<chart>
<title>September Chart</title>
<search>
<query>index=Auto log!=null location=farm fruit=apple | rename growTime as Duration | stats perc50(totalTimes) as s50, perc90(totalTimes) as s90 by Duration | table Duration, s50, s90 | untable Duration, percentile, value | chart first(value) over Duration by percentile</query>
<earliest>$earliest$</earliest>
<latest>$latest$</latest>
<refresh>1m</refresh>
<refreshType>delay</refreshType>
</search>
<option name="charting.axisLabelsX.majorLabelStyle.rotation">-45</option>
<option name="charting.chart">line</option>
<option name="charting.drilldown">none</option>
<option name="refresh.display">none</option>
<option name="charting.lineWidth">3</option>
</chart>
</panel>
<panel>
<chart>
<title>November Chart</title>
<search>
<query>index=Auto log!=null location=farm fruit=pear | rename growTime as Duration | stats perc50(totalTimes) as s50, perc90(totalTimes) as s90 by Duration | table Duration, s50, s90 | untable Duration, percentile, value | chart first(value) over Duration by percentile</query>
<earliest>$earliest$</earliest>
<latest>$latest$</latest>
<refresh>1m</refresh>
<refreshType>delay</refreshType>
</search>
<option name="charting.axisLabelsX.majorLabelStyle.overflowMode">ellipsisNone</option>
<option name="charting.axisLabelsX.majorLabelStyle.rotation">-45</option>
<option name="charting.chart">line</option>
<option name="charting.drilldown">none</option>
<option name="refresh.display">none</option>
<option name="charting.lineWidth">3</option>
</chart>
</panel>
<panel>
<chart>
<title>December Chart</title>
<search>
<query>index=Auto log!=null location=farm fruit=apricot | rename growTime as Duration | stats perc50(totalTimes) as s50, perc90(totalTimes) as s90 by Duration | table Duration, s50, s90 | untable Duration, percentile, value | chart first(value) over Duration by percentile</query>
<earliest>$earliest$</earliest>
<latest>$latest$</latest>
<refresh>1m</refresh>
<refreshType>delay</refreshType>
</search>
<option name="charting.axisLabelsX.majorLabelStyle.rotation">-45</option>
<option name="charting.chart">line</option>
<option name="charting.drilldown">none</option>
<option name="refresh.display">none</option>
<option name="charting.lineWidth">3</option>
</chart>
</panel>
</row>
</dashboard>
... View more