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!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...

Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...

After a whole week of being on call, you fell asleep on your keyboard, and you hit a sequence of buttons that ...