Splunk Search

chart count by Department,Project

kumasaua
Explorer

Dear ALL,

Need your support for calculating Column sum in last column..
I have employee master table.. need sum of all project members department wise.
1st column 2nd column 3rd column sum
12 15 23 50
25 10 10 45

My query is something like this |inputlookup abc.csv | chart count by Department,Project

Tags (1)
0 Karma

niketn
Legend

@kumasaua, try addtotals command which will add Total as final column by default.

| inputlookup abc.csv 
| chart count by Department,Project
| addtotals row=t col=f
____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Observability Unlocked: Kubernetes & Cloud Monitoring with Splunk IM

Ready to master Kubernetes and cloud monitoring like the pros? Join Splunk’s Growth Engineering team on ...

Index This | What did the zero say to the eight?

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

Splunk Observability Cloud's AI Assistant in Action Series: Onboarding New Hires & ...

This is the fifth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...