topic Re: How do I use the addcoltotals command with a stats list or stats values? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416904#M119971 <P>Hi,</P> <P>Can you try something like that</P> <PRE><CODE>| eventstats sum(Total) as GrandTotal by things | stats values(Total) as Total, values(example) as example values(GrandTotal) as GrandTotal by thing | table thing, example, Total,GrandTotal </CODE></PRE> <P>Doing the sum of the Total before should be a good solution.</P> <P>KailA</P> Thu, 04 Oct 2018 20:26:25 GMT KailA 2018-10-04T20:26:25Z How do I use the addcoltotals command with a stats list or stats values? https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416901#M119968 <P>How do I use <CODE>addcoltotals</CODE> with a stats list or with stats values?</P> <P>I'm trying to include the totals for each line value after running a stats list or values on a field with a numeric value and pipe <CODE>addcoltotals</CODE> , but it is skipping any values that are represented in my list or values table visualization. Anyone know how to get this to work?</P> <PRE><CODE>| stats values(Total) as Total, values(example) as example by thing | table thing, example, Total | addcoltotals labelfield=thing label="Grand Total:" </CODE></PRE> Thu, 04 Oct 2018 15:41:10 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416901#M119968 johnward4 2018-10-04T15:41:10Z Re: How do I use the addcoltotals command with a stats list or stats values? https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416902#M119969 <P>Can you please give an example of data or output that you are expecting? Anyways addcoltotals will not work with list or value as they are non-numeric</P> Thu, 04 Oct 2018 18:25:03 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416902#M119969 Vijeta 2018-10-04T18:25:03Z Re: How do I use the addcoltotals command with a stats list or stats values? https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416903#M119970 <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/5900i24F908EF31A458CA/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> Thu, 04 Oct 2018 20:17:44 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416903#M119970 johnward4 2018-10-04T20:17:44Z Re: How do I use the addcoltotals command with a stats list or stats values? https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416904#M119971 <P>Hi,</P> <P>Can you try something like that</P> <PRE><CODE>| eventstats sum(Total) as GrandTotal by things | stats values(Total) as Total, values(example) as example values(GrandTotal) as GrandTotal by thing | table thing, example, Total,GrandTotal </CODE></PRE> <P>Doing the sum of the Total before should be a good solution.</P> <P>KailA</P> Thu, 04 Oct 2018 20:26:25 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416904#M119971 KailA 2018-10-04T20:26:25Z Re: How do I use the addcoltotals command with a stats list or stats values? https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416905#M119972 <P>When you do list or value even on numeric values I believe the list command converts it into string and that is why you cannot add multivalued column. I would rather do it as</P> <PRE><CODE> stats sum(Total) by Example Thing </CODE></PRE> Thu, 04 Oct 2018 20:30:05 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416905#M119972 Vijeta 2018-10-04T20:30:05Z Re: How do I use the addcoltotals command with a stats list or stats values? https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416906#M119973 <P>Your search is almost correct try using sum(Total) instead of values.</P> <P>Your search | stats sum(Total) as Total by host | addcoltotals labelfield="fieldName" label="GrandTotal" | your table command</P> Fri, 05 Oct 2018 19:10:26 GMT https://community.splunk.com/t5/Splunk-Search/How-do-I-use-the-addcoltotals-command-with-a-stats-list-or-stats/m-p/416906#M119973 vinaykata 2018-10-05T19:10:26Z