Archive
Highlighted

pie chart with 2 search results

New Member

Hi

Search
index=index1 word1 AND word2 | stats count as card | appendcols [search index=index1 word1 AND NOT word2 | stats count as mail ]

Result
card mail
123 99

Expected Result
card 123
mail 99

so, i can see the results in a PIE chart

Thanks
nkk

Tags (1)
0 Karma
Highlighted

Re: pie chart with 2 search results

Esteemed Legend

Like this:

index1 word1 OR word2 | stats count(eval(searchmatch("word1 AND word2")) AS card count(eval(searchmatch("word1 AND NOT word2")) AS mail | transpose

View solution in original post

0 Karma