I am having issue with "Status" values as below and screenshot, please find below json and search query. Please advise!! Appreciate your help!   EventDate( 21/10/2022) EventDate( 20/10/2022) Expected "Status" DOCUMENT_ERROR:2 DOCUMENT_REQUEST_RECEIVED:2   Actual "Status" DOCUMENT_REQUEST_RECEIVED:2 DOCUMENT_ERROR:2   |eval Status = mvzip('eventData{}.eventStatusCount{}.status', 'eventData{}.eventStatusCount{}.count', ":") | table "eventData{}.eventDate","eventData{}.ReceivedCount", "eventData{}.ProcessedCount","eventData{}.MismatchCount","Status" | rename eventData{}.eventDate as "EventDate",eventData{}.ReceivedCount as "Total Event Received Count", eventData{}.ProcessedCount as "Total Event Processed Count", eventData{}.MismatchCount as "Total Event Mismatch Count"   "eventData": [ { "eventDate": "2022-10-20", "eventKey": "event.request", "ProcessedCount": 0, "eventStatusCount": [], "ReceivedCount": 100, "MismatchCount": 100 }, { "eventDate": "2022-10-21", "eventKey": "event.request", "ProcessedCount": 2, "eventStatusCount": [ { "status": "DOCUMENT_ERROR", "count": 2 }, { "status": "DOCUMENT_REQUEST_RECEIVED", "count": 2 } ], "ReceivedCount": 1000, "MismatchCount": 998 } ]     ... View more

I need to create a Dashboard with below columns  from below event data.   I couldn't able to get "Status" column value which is combination of  eventData{}.StatusCount{}.status and eventData{}.StatusCount{}.count Thanks in advance!!!   Dashboard five columns  and  expected values:       Date : "2021-10-14", eventKey: "event.request", ReceivedCount: 10, ProcessedCount: 10, MismatchCount: 0, Status :  DOCUMENT_REQUEST_RECEIVED:10 DOCUMENT_SUCCESS:10 DOCUMENT_NOTIFY_SUCCESS:10     "eventData": [ { "Date": "2021-10-14", "eventKey": "event.request", "ReceivedCount": 10, "ProcessedCount": 10, "MismatchCount": 0, "StatusCount": [ { "status": "DOCUMENT_REQUEST_RECEIVED", "count": 10 }, { "status": "DOCUMENT_SUCCESS", "count": 10 }, { "status": "DOCUMENT_NOTIFY_SUCCESS", "count": 10 } ] } ] ... View more