Dashboards & Visualizations

How to use 2 timepickers in splunk dashboard query

sngs0849
New Member

I have a dashboard query where I am comparing some stats between 2 different dates. I am able to use one time picker but not sure how to remove - (earliest=1587963600 latest=1588050000) and take it as a paramerter from timepicker.

 source=table1 (earliest=1587963600 latest=1588050000)
    | JOIN type=inner id 
    [ SEARCH source=table1  
    | rename user_id AS id ] </query>
              <earliest>$currentStatus.earliest$</earliest>
              <latest>$currentStatus.latest$</latest>
            </search>
0 Karma

to4kawa
Ultra Champion
<query>source=table1 | rename user_id AS id | eval flag="current"
| append [ search source=table1 (earliest=1587963600 latest=1588050000) 
| eval flag="before" ]
| stats AsYouLike by id </query>

I don't have accurate information, so this is about it.

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

&#x1f342; Fall into November with a fresh lineup of Community Office Hours, Tech Talks, and Webinars we’ve ...

Transform your security operations with Splunk Enterprise Security

Hi Splunk Community, Splunk Platform has set a great foundation for your security operations. With the ...

Splunk Admins and App Developers | Earn a $35 gift card!

Splunk, in collaboration with ESG (Enterprise Strategy Group) by TechTarget, is excited to announce a ...