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!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...