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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...