topic Re: How can I use fillnull to fill in different values for different fields? in Splunk Search

How can I use fillnull to fill in different values for different fields?

andrewtrobec — Tue, 29 Nov 2016 15:43:10 GMT

Hello,
I have a timechart that plots three values: incoming objects, outgoing objects, and the running amount of objects in the queue. If I call fillnull the timechart function will fill in entries with 0 where no data is present, but before I use it, I have the following table:

_time, IN, OUT, RUNNING
2016-11-01,1,0,1
2016-11-02,4,0,5
2016-11-03,3,6,2
2016-11-04,4,0,6
2016-11-05,1,0,7
2016-11-06,,, 
2016-11-07,1,2,6
2016-11-08,3,1,8
2016-11-09,1,0,9
2016-11-10,1,3,7
2016-11-11,1,0,8
2016-11-12,,, 
2016-11-13,,, 
2016-11-14,4,1,11
2016-11-15,4,2,13

The resulting line chart is:

When I use fillnull, it adds zeros and the graph stays the same:

_time, IN, OUT, RUNNING
2016-11-01,1,0,1
2016-11-02,4,0,5
2016-11-03,3,6,2
2016-11-04,4,0,6
2016-11-05,1,0,7
2016-11-06,0,0,0 
2016-11-07,1,2,6
2016-11-08,3,1,8
2016-11-09,1,0,9
2016-11-10,1,3,7
2016-11-11,1,0,8
2016-11-12,0,0,0 
2016-11-13,0,0,0 
2016-11-14,4,1,11
2016-11-15,4,2,13

What I'd like to do is ensure that the value for RUNNING stays constant while IN and OUT stay at 0:

_time, IN, OUT, RUNNING
2016-11-01,1,0,1
2016-11-02,4,0,5
2016-11-03,3,6,2
2016-11-04,4,0,6
2016-11-05,1,0,7
2016-11-06,0,0,7 
2016-11-07,1,2,6
2016-11-08,3,1,8
2016-11-09,1,0,9
2016-11-10,1,3,7
2016-11-11,1,0,8
2016-11-12,0,0,8 
2016-11-13,0,0,8 
2016-11-14,4,1,11
2016-11-15,4,2,13

How can I do this?

Thank you and best regards,

Andrew

Re: How can I use fillnull to fill in different values for different fields?

sundareshr — Tue, 29 Nov 2016 15:49:01 GMT

Use fillnull for IN/OUT and filldown for RUNNING.

| fillnull IN OUT value=0 | filldown RUNNING

http://docs.splunk.com/Documentation/Splunk/6.5.1/SearchReference/Fillnull

https://docs.splunk.com/Documentation/Splunk/6.5.1/SearchReference/Filldown

Re: How can I use fillnull to fill in different values for different fields?

richgalloway — Tue, 29 Nov 2016 15:49:07 GMT

Insert filldown RUNNING | before your fillnull command.

Re: How can I use fillnull to fill in different values for different fields?

andrewtrobec — Tue, 29 Nov 2016 16:05:22 GMT

I wish I could accept two answers, but thank you so much for your input as well!

Re: How can I use fillnull to fill in different values for different fields?

andrewtrobec — Tue, 29 Nov 2016 16:05:48 GMT

So simple... how did I not figure that out? Thanks so much!