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

[abhishekroy168]

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:)

[Nadhiyag]

you can use "fillnull" for the missing values

[deepashri_123]

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

[abhishekroy168]

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