Splunk Search

Fillnull not working on my search

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.

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


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, an upvote would be appreciated.