Archive

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

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

New Member

you can use "fillnull" for the missing values

0 Karma

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

Path Finder

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

0 Karma