| makeresults
| eval _raw="is_answered,has_duration,shown_questions,answered_questions,questions_durations
false,false,q1#q2#q4,q1#q2#q4,q1:3478#q2:3046#q4:12691
false,false,,,q1:1890
false,false,q1#q2#q4,q1#q2#q4,q1:2812#q2:3907#q4:4620
false,true,q1,,q1:0
false,false,,,q1:1551
false,false,q1#q3#q4,q1,q1:3488#q3:3399#q4:1791
false,false,q1#q3#q4,q1#q4,q1:8731#q3:1618#q4:8802
false,false,q1#q3#q4,q1#q4,q1:26155#q3:20770#q4:14013"
| multikv forceheader=1
| table is_answered,has_duration,shown_questions,answered_questions,questions_durations
| foreach *
[eval <<FIELD>>=split(<<FIELD>>,"#")]
`comment("Above is before mvexpand")`
`comment("From here, the logic")`
| streamstats count as session
| eval counter=if(isnull(shown_questions),0,mvrange(0,mvcount(shown_questions)))
| stats list(*) as * by session counter
| rename session as _session ,counter as _counter
| foreach *
[ eval <<FIELD>> = mvindex(<<FIELD>>,_counter)]
| table is_answered,has_duration,shown_questions,answered_questions,questions_durations
Hi, folks.
How about it?
Is mvexpand necessary?
... View more