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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Free Professional Services for .conf26 Attendees

This year at .conf26, we are doing something a little different. We are bringing the best minds from ...

Defend at Machine Speed: Your Guide to Security Sessions at .conf26

Splunk .conf26   With threats moving at machine speed and attack surfaces expanding across hybrid ...

Where Innovation Takes Flight: The Splunk4Aviation Flight Sim Lands at .conf26

If you hear someone at .conf26 shouting "gear down, GEAR DOWN" across the show floor, you have found us.  The ...