topic makemv and mvexpand empty results not showing in Splunk Search

makemv and mvexpand empty results not showing

yasaracar — Fri, 16 Oct 2015 14:24:21 GMT

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!

Re: makemv and mvexpand empty results not showing

HiroshiSatoh — Fri, 16 Oct 2015 18:58:40 GMT

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|

Re: makemv and mvexpand empty results not showing

yasaracar — Mon, 19 Oct 2015 11:44:49 GMT

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