Dashboards & Visualizations

How to get the job.resultCount for a dashboard panel search, not the base search?

roukepouw
Explorer

When using the following Dashboard and check the job.resultCount for the table element, it returns the number of the base search $QUERY$, not that of the filtered search $QUERY$ | where $FILTER$=1. How do I obtain that number of results?

<dashboard>
<search id="baseSearch">
     <query>$QUERY$</query>
</search>
<row>
  <table>

      <search base="baseSearch">
        <query>| where $FILTER$=1</query>
        <progress]
            <condition match="'job.resultCount' ] 1">
                <set token="check">true</set>
            </condition>
            <condition>
                <set token="check">false</set>
            </condition>
        </progress>
    &lt;/search&gt;
  </table>
   </panel>
</row>
</dashboard>
0 Karma

somesoni2
Revered Legend

Try like this

<dashboard stylesheet="eval_tokens.css">
  <label>Eval Tokens</label>
  <row>
    <panel >
      <chart>
        <title>Top sourcetypes for index=_internal</title>
        <search>
          <query>index=_internal sdfdsfdfdfdf|  top sourcetype</query>
          <earliest>-2h</earliest>
          <latest>now</latest>
          <progress>
            <eval token="duration">tonumber('job.resultCount')</eval>
          </progress>
        </search>

      <h3>Duration</h3>
      <div class="custom-result-value">$duration$</div>
  </html>

        <option name="charting.chart">bar</option>
      </chart>
     </panel>
  </row>
</dashboard>
Get Updates on the Splunk Community!

Observability | Use Synthetic Monitoring for Website Metadata Verification

If you are on Splunk Observability Cloud, you may already have Synthetic Monitoringin your observability ...

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...