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
0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...