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
Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!