https://community.splunk.com/t5/Splunk-Search/How-to-get-sum-for-unique-field-values/m-p/196808#M56814 <P>Hi,</P> <P>I saw that there is dc so we can get the distinct count but what if I want to get the sum for unique field values? I have tried something like this but it is missing some values. Any suggestions? </P> <P>base search | dedup field | stats sum(field) as sum</P> Thu, 12 Jun 2014 00:57:04 GMT xvxt006 2014-06-12T00:57:04Z https://community.splunk.com/t5/Splunk-Search/How-to-get-sum-for-unique-field-values/m-p/196808#M56814 <P>Hi,</P> <P>I saw that there is dc so we can get the distinct count but what if I want to get the sum for unique field values? I have tried something like this but it is missing some values. Any suggestions? </P> <P>base search | dedup field | stats sum(field) as sum</P> Thu, 12 Jun 2014 00:57:04 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-sum-for-unique-field-values/m-p/196808#M56814 xvxt006 2014-06-12T00:57:04Z https://community.splunk.com/t5/Splunk-Search/How-to-get-sum-for-unique-field-values/m-p/196809#M56815 <P>Is this what you mean?</P> <PRE><CODE>base search | stats sum(value) as sum by field </CODE></PRE> <P>Some example data would help, if that's not what you needed.</P> Thu, 12 Jun 2014 04:37:30 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-sum-for-unique-field-values/m-p/196809#M56815 s2_splunk 2014-06-12T04:37:30Z https://community.splunk.com/t5/Splunk-Search/How-to-get-sum-for-unique-field-values/m-p/196810#M56816 <P>Hi Thanks for checking. I have figured out this.</P> Tue, 17 Jun 2014 19:07:28 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-sum-for-unique-field-values/m-p/196810#M56816 xvxt006 2014-06-17T19:07:28Z