Splunk Search

How to change timechart data points to reflect full timestamp instead of date_hours

jonleach
New Member

Disclaimer - very green to Splunk

My timechart is built with the following

$search | timechart avg(date_hour) by date_mday

And the chart itself looks fine but because im only asking for date_hour each point only reflects the hour portion of each log's time stamp. Can I change my query so the alt text for each data point on the chart reflect the full time stamp?

Also, my x axis properly sorts point by day but my y axis bounds are off - can I set the max and min myself?

THANK YOU

0 Karma
1 Solution

jawaharas
Motivator

Try 'span' keyword in 'timechart' command

<base_search>
| timechart span=1h avg(field_name)

View solution in original post

0 Karma

jawaharas
Motivator

Try 'span' keyword in 'timechart' command

<base_search>
| timechart span=1h avg(field_name)
0 Karma

jonleach
New Member

Adding span gets me exactly what I needed, thanks!

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  &#x1f680; Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...