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!

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...