Dashboards & Visualizations

+/- 30 minutes from timestamp of table on a dashboard

treverce
Explorer

I have a dashboard that generates a table that I would like to add the ability to jump into search from the table on the dashboard. We have hundreds of TB of data a day in the index so id like for it to limit the timeframe down to +/- 30m of the timestamp that I have. So if the timestamp of the event is 8:21pm I want to make the search be something like

```

index=index field=field earliest=(timestamp-30m) latest=(timestamp+30m)

```

How could I achieve this via the dashboard XML?

 

Thanks!

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

You can use eval to set tokens like this.

<drilldown>
  <eval token="st">$row._time$-1800</eval>
  <eval token="et">$row._time$+1800</eval>
</drilldown>

Then pass $st$ and $et$ to the drilldown dashboard. 

---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

You can use eval to set tokens like this.

<drilldown>
  <eval token="st">$row._time$-1800</eval>
  <eval token="et">$row._time$+1800</eval>
</drilldown>

Then pass $st$ and $et$ to the drilldown dashboard. 

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...