Splunk Search

makemv and mvexpand empty results not showing

yasaracar
Explorer

I need to see which questions a user answered. It is a multiple value field. Possible values:

question="1" or question="1,3" or question="" ....

I want to create a chart. My search is:

makemv delim="," question| mvexpand question| eval question= case(question==1, "Question-1", question==2,"Question-2", question==3,"Question-3",question=="","Not Filled") | chart  count by question

But it doesn't show the results for empty string "" value. Does anybody know a way to do that?

Cheers!

0 Karma
1 Solution

HiroshiSatoh
Champion

I think that where the value is gone.

|makemv delim="," question| mvexpand question

Try this!

|eval question=if(question=="",",",question)|makemv allowempty=true delim="," question| mvexpand question|

View solution in original post

HiroshiSatoh
Champion

I think that where the value is gone.

|makemv delim="," question| mvexpand question

Try this!

|eval question=if(question=="",",",question)|makemv allowempty=true delim="," question| mvexpand question|

yasaracar
Explorer

Thanks! "eval if" was the key point to solve the problem.

The final query that works:

|eval question=if(question=="","Not Filled",question) |makemv allowempty=true delim="," question| mvexpand question | eval question= case(question==1, "Question-1", question==2,"Question-2", question==3,"Question-3",question=="Not Filled","Not Filled") | chart  count by question
0 Karma
Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...