Hello,
I am looking for a better approach to calculate a duration per event if I have a time series data with multiple events. Today we are doing it by pulling all the events per User and running the logic on Javascript but looking for alternatives if N1QL can do better here.
Dataset example:
{
"user_id": "user:1234",
"createdAt": "2020-06-01T14:00:00Z",
"event": "DRIVING"
},
{
"user_id": "user:1234",
"createdAt": "2020-06-01T14:10:20Z",
"event": "STOP_AT_LIGHT"
},
{
"user_id": "user:1234",
"createdAt": "2020-06-01T14:11:10Z",
"event": "DRIVING"
},
{
"user_id": "user:1234",
"createdAt": "2020-06-01T14:45:00Z",
"event": "STOPPED"
},
{
"user_id": "user:4567",
"createdAt": "2020-06-01T15:08:00Z",
"event": "DRIVING"
},
{
"user_id": "user:4567",
"createdAt": "2020-06-01T15:12:00Z",
"event": "STOP_AT_LIGHT"
},
{
"user_id": "user:4567",
"createdAt": "2020-06-01T15:12:45Z",
"event": "DRIVING"
},
{
"user_id": "user:1234",
"createdAt": "2020-06-01T15:05:00Z",
"event": "DRIVING"
},
{
"user_id": "user:1234",
"createdAt": "2020-06-01T15:10:00Z",
"event": "STOP_AT_LIGHT"
},
{
"user_id": "user:1234",
"createdAt": "2020-06-01T15:11:00Z",
"event": "DRIVING"
},
{
"user_id": "user:1234",
"createdAt": "2020-06-01T15:35:00Z",
"event": "STOPPED"
}
]
The goal is to figure out the duration between each event say how long the Driver waited at the light.