https://community.splunk.com/t5/Splunk-Search/how-to-sum-of-count-of-values-of-fields/m-p/138087#M184777 <P>Can you provide more information on how it didn't work? Also, please check the name of fields and apply those in the answer provided here.</P> Wed, 23 Apr 2014 15:02:50 GMT somesoni2 2014-04-23T15:02:50Z https://community.splunk.com/t5/Splunk-Search/how-to-sum-of-count-of-values-of-fields/m-p/138084#M184774 <P>Hi,<BR /> I have a search and output.<BR /> source="risks_repor.csv"| dedup "Computer Name" | search D- </P> <H2>Output:</H2> <H2>values count %</H2> <P>Cleaned by deletion 10 19.608% </P> <P>Left alone 6 11.765% </P> <P>Deleted 5 9.804% </P> <P>Cleaned 4 7.843% </P> <H1>Question:</H1> <P>sum as "Some string"="Cleaned by deletion" + "Left alone"<BR /> sum1 as "Some string1"="Deleted" + "Cleaned"</P> <H1>Expected output:</H1> <H1>Some string Some string1 </H1> <P>16 9</P> Tue, 22 Apr 2014 09:19:04 GMT https://community.splunk.com/t5/Splunk-Search/how-to-sum-of-count-of-values-of-fields/m-p/138084#M184774 thambisetty 2014-04-22T09:19:04Z https://community.splunk.com/t5/Splunk-Search/how-to-sum-of-count-of-values-of-fields/m-p/138085#M184775 <P>Hi,</P> <BLOCKQUOTE> <P><CODE>source="risks_repor.csv".....|table value count |where value="Cleaned" OR value ="Deleted"|stats sum(count) as Somestring1|<BR /> appendcols[search source="risks_repor.csv".....|table value count|where value="Left alone" OR value ="Cleaned by deletion"|stats sum(count) as Somestring]</CODE></P> </BLOCKQUOTE> <P>I hope this helps..!!!</P> Tue, 22 Apr 2014 12:02:17 GMT https://community.splunk.com/t5/Splunk-Search/how-to-sum-of-count-of-values-of-fields/m-p/138085#M184775 harshal_chakran 2014-04-22T12:02:17Z https://community.splunk.com/t5/Splunk-Search/how-to-sum-of-count-of-values-of-fields/m-p/138086#M184776 <P>this is not working i tried it....</P> Wed, 23 Apr 2014 14:51:05 GMT https://community.splunk.com/t5/Splunk-Search/how-to-sum-of-count-of-values-of-fields/m-p/138086#M184776 thambisetty 2014-04-23T14:51:05Z https://community.splunk.com/t5/Splunk-Search/how-to-sum-of-count-of-values-of-fields/m-p/138087#M184777 <P>Can you provide more information on how it didn't work? Also, please check the name of fields and apply those in the answer provided here.</P> Wed, 23 Apr 2014 15:02:50 GMT https://community.splunk.com/t5/Splunk-Search/how-to-sum-of-count-of-values-of-fields/m-p/138087#M184777 somesoni2 2014-04-23T15:02:50Z