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!

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...