How to calculate sum (distinct_count by column1) and display as a number in visualization?

[waghuldese1]

I have a stats calculated using :

stats distinct_count(c1) by c2

Now I want to calculate the sum of these distinct_counts and display as a single number.

[Vijeta · Accepted solution]

@waghuldese1

<your query>| stats distinct_count(c1) as dc by c2| stats sum(dc) as sum