Archive

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

New Member

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.

Tags (1)
0 Karma
1 Solution

Influencer

@waghuldese1

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

View solution in original post

Influencer

@waghuldese1

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

View solution in original post

Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes and swag!