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!

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...