Dashboards & Visualizations
Highlighted

Pass stats count value from a search command to a token, and display tokens in an HTML panel

Path Finder

Hello all,

Is there a way to pass the number derived from stats count to a token?

I need to make an HTML panel consisting of text like so:

Incident
New VS. Resolved
o   42 new incidents
o   54 resolved incidents (all P3 and P4s)

Values 42 and 54 come from search queries like so:

For 42:
| search status="*"
| stats count(ticket) as New

For 54:
| search status="Resolved"
| stats count(ticket) as Resolved

Is there a way to pass the values of New and Resolved from the search queries to tokens in the dashboard so I can display it inside my HTML panel?

0 Karma
Highlighted

Re: Pass stats count value from a search command to a token, and display tokens in an HTML panel

Esteemed Legend
0 Karma
Highlighted

Re: Pass stats count value from a search command to a token, and display tokens in an HTML panel

Champion

Hi @dojiepreji

Try like

       <search>
          <query>your query......| search status="*"
                | stats count(ticket) as New</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
          <done>
            <condition>
              <set token="new_incident">$result.New$</set>
            </condition>
          </done>
        </search>
0 Karma
Highlighted

Re: Pass stats count value from a search command to a token, and display tokens in an HTML panel

Champion

@dojiepreji, have you tried?

0 Karma
Highlighted

Re: Pass stats count value from a search command to a token, and display tokens in an HTML panel

Champion

Any update?

0 Karma