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
Get Updates on the Splunk Community!

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...