https://community.splunk.com/t5/Splunk-Search/How-to-sum-2-percent/m-p/522021#M147183 <P>Sorry, I want to average them.</P> Tue, 29 Sep 2020 15:17:13 GMT mah 2020-09-29T15:17:13Z https://community.splunk.com/t5/Splunk-Search/How-to-sum-2-percent/m-p/522011#M147178 <P>Hi,</P><P>I have a table like that :&nbsp;</P><TABLE border="1" width="100%"><TBODY><TR><TD width="50%">name</TD><TD width="50%">percent</TD></TR><TR><TD width="50%">AAA</TD><TD width="50%">90</TD></TR><TR><TD width="50%">BBB</TD><TD width="50%"><P>60</P><P>70</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want to group the BBB percent in one percent.</P><P>How I can do this command ?&nbsp;</P><P>Thanks</P> Tue, 29 Sep 2020 14:37:09 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sum-2-percent/m-p/522011#M147178 mah 2020-09-29T14:37:09Z https://community.splunk.com/t5/Splunk-Search/How-to-sum-2-percent/m-p/522015#M147180 <P>How do you want to "group" them? Add them together, multiply them together, take an average, join them with a space/comma between?</P> Tue, 29 Sep 2020 14:53:28 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sum-2-percent/m-p/522015#M147180 ITWhisperer 2020-09-29T14:53:28Z https://community.splunk.com/t5/Splunk-Search/How-to-sum-2-percent/m-p/522021#M147183 <P>Sorry, I want to average them.</P> Tue, 29 Sep 2020 15:17:13 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sum-2-percent/m-p/522021#M147183 mah 2020-09-29T15:17:13Z https://community.splunk.com/t5/Splunk-Search/How-to-sum-2-percent/m-p/522028#M147185 <LI-CODE lang="markup">-- your search | streamstats count as row | eventstats sum(percent) as total by row | eval percent=round(total/mvcount(percent),2) | fields - row total</LI-CODE> Tue, 29 Sep 2020 15:41:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sum-2-percent/m-p/522028#M147185 ITWhisperer 2020-09-29T15:41:23Z