Reporting

adding a dummy row

kajolsharma
Path Finder

Hi , I want to add a row total=0 in the below table .Can somebody suggest?

kajolsharma_0-1631028313227.png

query used is:  index="monthend" source="Period End Tracker_6Sep'21.csv"|rename "Activity Name" as Activity|dedup Activity|eval status_1=if(Activity=="Month End Closing for AP,AR & GL","Delay","On Track")|stats count by status_1

Labels (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| append [| makeresults
  | eval status_1="Total"
  | eval count=0]
0 Karma

kajolsharma
Path Finder

Here i m getting count as 0 .Wat if I want the actual count of below statuses :-

kajolsharma_0-1634714910938.png

 

query used - |inputlookup append=t Month_End_Tracker.csv|dedup "Activity Name"|stats count by Status|append [| makeresults
| eval Status="Total"
| eval count=0]|table Status count

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| addcoltotals labelfield=Status label=Total
0 Karma
*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!

Review:





Or Learn More in Our Blog >>