Splunk Search

Splunk Statistics table with totals column

jackson1990
Path Finder

Below is my CSV Data :


Company, Model,Year
Honda, Civic, 2016
Toyota, Camry, 2017
Honda, Accord, 2016
Honda, Civic SE,2017
Honda, Fit, 2017
Honda, Fit EV, 2017
Toyota, Corolla, 2016

Toyota, Yaris, 2017

The fields auto extracted by splunk are Company,Model and Year.
When i make a "chart count over Company by Year | addtotals " and change to statistics table in Splunk simple xml Dashboard visualizations,i get the result as
alt text

My requirement is to get the totals field as second column.

Expected:
alt text

IF not possible through the above way,kindly suggest a way to achieve the expected stats table,with total field as second column.
Thanks in Advance

0 Karma
1 Solution

s2_splunk
Splunk Employee
Splunk Employee

Try this: chart count over Company by Year | addtotals | fields Company, Total, *

View solution in original post

s2_splunk
Splunk Employee
Splunk Employee

Try this: chart count over Company by Year | addtotals | fields Company, Total, *

jackson1990
Path Finder

Worked like a charm....
Thanks Ssievert

0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

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

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...