- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yasaracar
Explorer
10-16-2015
07:24 AM
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!
1 Solution
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

HiroshiSatoh
Champion
10-16-2015
11:58 AM
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|
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

HiroshiSatoh
Champion
10-16-2015
11:58 AM
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|
- Mark as New
- Bookmark Message
- Subscribe to Message
- Mute Message
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
yasaracar
Explorer
10-19-2015
04:44 AM
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
