Splunk Enterprise

help on timechart click value

jip31
Motivator

hello

I use a click value token on my timechart in order to display details

it works but now what I need is when I click on a specific bar of my timechart (it means a bar for a specific day) I need to display only the data for this date

how to do this please

<search>
          <query>index=tutu sourcetype=toto ezconf=$ezconf$ 
| timechart span=1d count(hang)as hang</query>
          <earliest>-7d@h</earliest>
          <latest>now</latest>
        </search>
        <drilldown>
          <set token="hang">$click.value$</set>
        </drilldown>
      </chart>
    </panel>
  </row>
  <row>
    <panel depends="$hang$">
      <title></title>
      <table>
        <title></title>
        <search>
          <query>index=toto sourcetype=tutu ezconf=$ezconf$ 
| eval time = strftime(_time, "%d-%m-%y %H:%M") 
| sort - time 
| table time hang</query>
          <earliest>-7d@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </table>
    </panel>

 

Tags (1)
0 Karma
1 Solution

tscroggins
Influencer

@jip31 

The earliest and latest values are available as tokens:

<drilldown>
  <set token="earliest_tok">$earliest$</set>
  <set token="latest_tok">$latest$</set>
</drilldown>

You can use these tokens in your other visualization searches:

<search>
  <query>index=toto sourcetype=tutu ezconf=$ezconf$ 
| eval time = strftime(_time, "%d-%m-%y %H:%M") 
| sort - time 
| table time hang</query>
  <earliest>$earliest_tok$</earliest>
  <latest>$latest_tok$</latest>
</search>

You can initialize earliest_tok and latest_tok to default values using a time input or a combination of <init> and <set> tags.

View solution in original post

0 Karma

tscroggins
Influencer

@jip31 

The earliest and latest values are available as tokens:

<drilldown>
  <set token="earliest_tok">$earliest$</set>
  <set token="latest_tok">$latest$</set>
</drilldown>

You can use these tokens in your other visualization searches:

<search>
  <query>index=toto sourcetype=tutu ezconf=$ezconf$ 
| eval time = strftime(_time, "%d-%m-%y %H:%M") 
| sort - time 
| table time hang</query>
  <earliest>$earliest_tok$</earliest>
  <latest>$latest_tok$</latest>
</search>

You can initialize earliest_tok and latest_tok to default values using a time input or a combination of <init> and <set> tags.

0 Karma
Get Updates on the Splunk Community!

Building Reliable Asset and Identity Frameworks in Splunk ES

 Accurate asset and identity resolution is the backbone of security operations. Without it, alerts are ...

Cloud Monitoring Console - Unlocking Greater Visibility in SVC Usage Reporting

For Splunk Cloud customers, understanding and optimizing Splunk Virtual Compute (SVC) usage and resource ...

Automatic Discovery Part 3: Practical Use Cases

If you’ve enabled Automatic Discovery in your install of the Splunk Distribution of the OpenTelemetry ...