Hi
Can you please try this?
YOUR SEARCH | stats delim="," list(Type) as Type list(_time) as Time list(Result) as Result by acct | mvcombine Time | mvcombine Type | mvcombine Result | eval Type1=mvindex(split(Type,","),0),Type2=mvindex(split(Type,","),1),Start_Time=strftime(mvindex(split(Time,","),0),"%Y-%m-%d %H:%M:%S"),End_Time=strftime(mvindex(split(Time,","),1),"%Y-%m-%d %H:%M:%S") ,Result1=mvindex(split(Result,","),0),Result2=mvindex(split(Result,","),1) | table acct Type1 Start_Time Result1 Type2 End_Time Result2
Thanks
... View more