Splunk Search

Chart not displaying unique counts

sheloaha
Path Finder

I'm trying to chart the count of how many different methods are detected during a specific search. The methods are in different fields so I am using makemv and delim to create one field called "method". When I do chart or stats count by method I get a pie chart that contains equal sections. I need to have the actual count of each method instead. What am I missing?

basic search | transaction UID | rename fieldA as Create, fieldB as Close, fieldC as Update, fieldD as PostClose, fieldE as Reopen |eval method="Create,Close,Update,PostClose,Reopen" | makemv method delim=","| mvexpand method | chart count by method

Tags (4)
0 Karma
1 Solution

woodcock
Esteemed Legend

Your mistake is using transaction and also mvexpand try this instead:

basic search
| stats values(*) AS * BY UID 
| rename fieldA as Create, fieldB as Close, fieldC as Update, fieldD as PostClose, fieldE as Reopen 
| eval method=mvappend(Create,Close,Update,PostClose,Reopen)
| chart count BY method

View solution in original post

0 Karma

woodcock
Esteemed Legend

Your mistake is using transaction and also mvexpand try this instead:

basic search
| stats values(*) AS * BY UID 
| rename fieldA as Create, fieldB as Close, fieldC as Update, fieldD as PostClose, fieldE as Reopen 
| eval method=mvappend(Create,Close,Update,PostClose,Reopen)
| chart count BY method

View solution in original post

0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.