Hello! I have some JSON events that each look something like this: {
"id": 12345,
"steps": [
{
"stepName": "A",
"stepDuration": 0.5
},
{
"stepName": "B",
"stepDuration": 0.17
}
]
} My existing searches are set up to do a mvexpand() based on the steps field such that each step becomes its own event which I am able to manipulate. This works great for small numbers of events, but when I am processing thousands of events with 100+ steps each, I am quickly running into the memory limitations imposed on the mvexpand function by default. Is there an alternative function that I am missing that I can use to compute summary statistics such as "the average duration of step A is X.XX" and "X% of events hit step B"? If not, is there a better way to structure the events themselves to support this? My constraint is that I need to allow for arbitrary numbers of steps occurring in an arbitrary order that needs to be preserved. Thanks in advance!
... View more