Splunk Search

How to display a table with time interval of 1 hour, starting at the 30 minute mark?

ankithreddy777
Contributor

I used timechart command to display 1 hour intervals data. I am getting results starting from 00:00 with 1 hour interval. How I can display results with span=1h but 30th minute start time, like 1:30-2:30, 2:30 to 3:30 etc.

0 Karma
1 Solution

somesoni2
Revered Legend

I dont think there is any straight way to do that. Try this workaround

your base search | eval _time=_time-1800 | timechart span=1h ...whatever you've... | eval _time=_time+1800

View solution in original post

somesoni2
Revered Legend

I dont think there is any straight way to do that. Try this workaround

your base search | eval _time=_time-1800 | timechart span=1h ...whatever you've... | eval _time=_time+1800
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...