Splunk Search

Not showing count in a table

Harish2
Path Finder

We are seeing a very different issue,
1.As shown  in a table when there are no logs for any one of the List rows are returning null values. eg: App2 and App3 column. used |fillnull value=0 its not working.
2. If we have data for any one of the Service(eg: service=fast, App4 column), it showing the count and rest of the rows are filling up with zero.

how to fill the null values as zero even when there are no single count for the columns??

Query: 
index=testindex source=sourcelogs
|rex field= _raw "service :\s(?<Service>\w+)"
| rex field= _raw "(?<List>Received main message|Application published to service|List status are in process|Application process running successfully)"
|chart count over Service by List
|rename "Received main message" as App1 "Application published to service" as App2 "List status are in process" as App3 "Application process running successfully" as App4
|table App1 App2 App3 App4

Result of the query:

ServiceApp1App2App3App4
Token10  0
Modern40  0
Surb3  0
Fast12  4
Normal4  0
Forward6  0
Medium7  0
Labels (1)
0 Karma

yuanliu
SplunkTrust
SplunkTrust

What have you tried?  What is the result of your trial(s)?  Or is this some sort of homework that everybody is posting for an answer? (Yes, this exact same question came up again and again in recent days.)

The syntax of fillnull is no secret:

|fillnull App1 App2 App3 App4

Now, you just show us how you use it and what results do you get.  No cheating:-)

0 Karma

Harish2
Path Finder

Before I tried at end my query as 

|fillnull value=0

 which did not work 

now I tried 

fillnull App1 App2 App2 App4

its working 

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Observability Simplified: Combining User Experience, Application Performance & ...

Tech Talk Observability Simplified: Combining User Experience, Application Performance & Network ...

Event Series May & June: From Network Visibility to Service Intelligence

Unifying the Network: Moving from Alert Noise to Service Intelligence with Splunk ITSI In today’s hybrid ...

Global Splunk User Group Events: May + June 2026

Your Splunk Community Awaits: Discover Upcoming User Group Events Worldwide    Staying ahead in the fast-paced ...