Splunk Search

Display chart only within Time range where there data exists

Dark_Ichigo
Builder

I want to display a chart that automatically crops that whole chart to where there is data and not display any empty before or after time ranges where there is no data at all, how can this be done?

Please let me know if more information is required.

1 Solution

lguinn2
Legend

In your timechart command, use the option

fixedrange=false

for example

yoursearchhere
| timechart fixedrange=false count

then the timechart X-axis will be cropped to only the timerange that includes valid data.

Documentation for timechart command

View solution in original post

lguinn2
Legend

In your timechart command, use the option

fixedrange=false

for example

yoursearchhere
| timechart fixedrange=false count

then the timechart X-axis will be cropped to only the timerange that includes valid data.

Documentation for timechart command

sansay
Contributor

That worked perfectly for my purpose.
I combined data from 2 different days, and shifted the date of the first day so that timechart would show them at the same times, but I ended with an empty set. This solved my problem. Thank you very much!

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Federated Search for Snowflake Is Now Generally Available on Splunk Cloud Platform

Splunk is excited to announce the General Availability (GA) of Federated Search for ...

Help Us Build Better Splunk Regex Puzzles (And Win Prizes!)

If you’ve spent any time in the Splunk Community Slack, you’ve likely seen our resident Splunk Trust ...

Fuel Your Journey: What’s Waiting for You at the .conf26 Acceleration Station

Navigating the show floor at .conf26 isn't just about keynotes and technical breakout sessions; it's also ...