Hi , I want to add a row total=0 in the below table .Can somebody suggest?
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
| append [| makeresults
| eval status_1="Total"
| eval count=0]
Here i m getting count as 0 .Wat if I want the actual count of below statuses :-
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
| addcoltotals labelfield=Status label=Total