Splunk Enterprise

help on basic question about span in timechart

jip31
Motivator

hello

I use a one hour span in my timechart but I dont understand why a two hour span is displayed on the timechart abscissa instead one hour?

| timechart span=1h max(debut) as "Début de session", max(fin) as "Fin de session"

thanks

 

 

Tags (1)
0 Karma
1 Solution

PickleRick
SplunkTrust
SplunkTrust

The only situation that timechart seems to be doing strange things is when _time is outside of your search range. For example:

| makeresults count=10 
| streamstats count
| eval _time=_time+7200*count
| timechart span=1h count

 It indeed aligns the results to the full hours for which there is data.

If you run this search with any "past" time range chosen from the time picker, it will give you results spread over 2-hour span. If you chose "any time" however, you'll get proper 1-hour spans with alternating 0 and 1 values.

It looks like a bug.

View solution in original post

PickleRick
SplunkTrust
SplunkTrust

Hmm, it's hard to believe since it's span's function to define the... span size.

Can you show us the results of:

<<your_search_with_timechart>> 
| autoregress _time as oldtime
| eval diff=_time-oldtime
| stats count by diff

 

0 Karma

jip31
Motivator

count is 11 and diff 7200

 

0 Karma

PickleRick
SplunkTrust
SplunkTrust

The only situation that timechart seems to be doing strange things is when _time is outside of your search range. For example:

| makeresults count=10 
| streamstats count
| eval _time=_time+7200*count
| timechart span=1h count

 It indeed aligns the results to the full hours for which there is data.

If you run this search with any "past" time range chosen from the time picker, it will give you results spread over 2-hour span. If you chose "any time" however, you'll get proper 1-hour spans with alternating 0 and 1 values.

It looks like a bug.

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 ...