I have an use case to calculate time difference between events grouped together by transaction command. Example is given below.
{
"timeStamp": "Fri 2020.03.27 01:10:34:1034 AM EDT",
"step": "A"
}
{
"timeStamp": "Fri 2020.03.27 01:10:38:1038 AM EDT",
"step": "B",
}
{
"timeStamp": "Fri 2020.03.27 01:10:39:1039 AM EDT",
"step": "C"
}
{
"timeStamp": "Fri 2020.03.27 01:10:40:1034 AM EDT",
"step": "D"
}
I have two requirements.
Will it be possible to get time difference between consecutive steps ?
STEP B 4 sec
STEP C 1 sec
STEP D 1 sec
If above is possible how can I get average elapsed time between two steps for all the transactions which have Step A, B, C, D ?
... View more