Splunk Search

Fillnull not working on my search

markhvesta
Path Finder

I am trying to get the following query to work, but if there are no InPerson orders, no results are shown for the Channel instead of a row with 0 orders.

 sourcetype="CustomerOrders"
| search (Channel = Store 
OR Channel = InPerson)
| chart count as Count by Channel
|fillnull
0 Karma

richgalloway
SplunkTrust
SplunkTrust

The fillnull command will add values to fields within a row, but does not create rows that don't exist.

---
If this reply helps you, Karma would be appreciated.
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk on November 6 at 11AM PT, and empower your SOC to reach new heights! Duration: ...

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...