Splunk Search

Adding months with no data or you can say displaying months which are not present in my csv file into a bar representation.

abhishekroy168
Path Finder

Hi all,
My requirement is to display incidents raised within a date range.The range i am comparing with a date field in my CSV file.
Now for dates not present in my csv the graph displays nothing related to those months.
My requirement is to display all months within the selected date range whether the date be present or not in the CSV.
I have used timechart but it doesnt considers the date range.
Any idea please share:)

Tags (1)
0 Karma

Nadhiyag
Explorer

you can use "fillnull" for the missing values

0 Karma

deepashri_123
Motivator

hey abhishekroy2018,

You can refer the link below:
https://answers.splunk.com/answers/523189/how-to-use-timechart-count-to-return-0-when-value.html

Let me know if this helps!!

0 Karma

abhishekroy168
Path Finder

thanks for the reply.
Yes it workexd with little modification in the given query.

0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...