https://community.splunk.com/t5/Splunk-Search/How-to-calculate-sum-distinct-count-by-column1-and-display-as-a/m-p/427980#M170691 <P>I have a stats calculated using :</P> <P>stats distinct_count(c1) by c2</P> <P>Now I want to calculate the sum of these distinct_counts and display as a single number.</P> Tue, 18 Jun 2019 14:19:46 GMT waghuldese1 2019-06-18T14:19:46Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-sum-distinct-count-by-column1-and-display-as-a/m-p/427980#M170691 <P>I have a stats calculated using :</P> <P>stats distinct_count(c1) by c2</P> <P>Now I want to calculate the sum of these distinct_counts and display as a single number.</P> Tue, 18 Jun 2019 14:19:46 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-sum-distinct-count-by-column1-and-display-as-a/m-p/427980#M170691 waghuldese1 2019-06-18T14:19:46Z https://community.splunk.com/t5/Splunk-Search/How-to-calculate-sum-distinct-count-by-column1-and-display-as-a/m-p/427981#M170692 <P>@waghuldese1 </P> <PRE><CODE>&lt;your query&gt;| stats distinct_count(c1) as dc by c2| stats sum(dc) as sum </CODE></PRE> Tue, 18 Jun 2019 14:26:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-calculate-sum-distinct-count-by-column1-and-display-as-a/m-p/427981#M170692 Vijeta 2019-06-18T14:26:23Z