Splunk Search

makecontinuous not working for first/initial time span

VS0909
Communicator

If I run the below query for last 7 days, and if there is no data in logs matching condition index=abc "searchTerm" for day1, then the results are showing for day2 to day7.

But I want a row in resultset for day1 as well, if no data then with TotalResults as 0 for day1.

index=abc "searchTerm"  | bucket _time span=1d | stats count as TotalResults by _time | makecontinuous _time | fillnull TotalResults

Please help

 

0 Karma

VS0909
Communicator

@ITWhisperer  Thanks for the reply!

Can you please help with the complete query here, considering day1 and day7 and also days in between, as same problem may happen for other days as well.

Appreciate your help

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

makecontinuous works between the lowest value in the field and the highest value in the field - you will need to add (append) a dummy entry for day 1 with TotalResults value of 0. I would then sum the TotalResults by _time (in case there was already a result for day 1, then do the makecontinous etc.

VS0909
Communicator

@ITWhisperer  Thanks for the reply!

Can you please help with the complete query here, considering day1 and day7 and also days in between, as same problem may happen for other days as well.

Appreciate your help

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| append 
    [| makeresults
    | addinfo
    | rename info_min_time as _time
    | bin _time span=1d
    | fields - info_*]
| sort _time
| makecontinuous _time span=1d
| fillnull value=0 TotalResults
| stats sum(TotalResults) as TotalResults by _time
Get Updates on the Splunk Community!

Observability | How to Think About Instrumentation Overhead (White Paper)

Novice observability practitioners are often overly obsessed with performance. They might approach ...

Cloud Platform | Get Resiliency in the Cloud Event (Register Now!)

IDC Report: Enterprises Gain Higher Efficiency and Resiliency With Migration to Cloud  Today many enterprises ...

The Great Resilience Quest: 10th Leaderboard Update

The tenth leaderboard update (11.23-12.05) for The Great Resilience Quest is out >> As our brave ...