first posts here in elasticsearch forum and new to this exciting technology.
working on a proof of concept and already loaded/indexed some data into elastic.
Data is structured like the sample bellow:
SIG201600064827 Registo do Pedido - Submetida em 2016-05-22 15:19:11.357 JANDRADE42
SIG201600064827 Registo do Pedido - Finalizada em 2016-05-22 15:19:25.220 SISTEMA
SIG201600064827 Validação do Pedido - Atribuída em 2016-05-22 15:20:00.300 JJESUS01
The challenge here is to calculate the duration of the event.
Each line of the above sample is one step, so , as we can see , the task in the sample above has been completed in 3 steps.
How can i build an aggregation and calculate the duration of the task ?
duration = time of step "Validação do Pedido - Atribuída em" - time of step "Registo do Pedido - Submetida em"