Replacing null values by using the fillnull and filldown commands
Null values are field values that are missing in a particular result but are present in another result. You're finding that some of your searches result in a lot of null values, which can make your reports look confusing or messy. You'd like to replace them with something different.
You can use
filldown to replace null values in your results. The
fillnull command replaces null values in all fields with a zero by default. The
filldown command replaces null values with the last non-null value for a field or set of fields.
This video shows you both commands in action.
This article has been brought to you by Splunk Education. We’ve learned that the strongest superheroes up-skill with Splunk Education. That’s why we are making Splunk training easier and more accessible than ever with more than 20 self-paced, free eLearning courses. You can start with foundational courses like Intro to Splunk or dive into more advanced courses like Search Under the Hood, Result Modification, and many more. Enroll today so you have the skills to detect the good, the bad, and the unproductive.
In addition, these resources might help you understand and implement this guidance:
Still need help with this use case? Most customers have OnDemand Services per their license support plan. Engage the ODS team at OnDemand-Inquires@splunk.