@anissabnk so do you have ONE of each libelle per event, if so then how do you define response time - is it the TIME of the event, so BT time is OUT time - IN time and is there only a SINGLE one of e...
See more...
@anissabnk so do you have ONE of each libelle per event, if so then how do you define response time - is it the TIME of the event, so BT time is OUT time - IN time and is there only a SINGLE one of each libelle per flux? Try something like this index="bloc1rg" AND libelle IN (IN_PREC, OUT_PREC, IN_BT, OUT_BT, IN_RANG, OUT_RANG) earliest=-1mon@mon latest=-1d@d
| stats max(eval(if(libelle="IN_PREC", _time, null()))) as IN_PREC_TIME
max(eval(if(libelle="OUT_PREC", _time, null()))) as OUT_PREC_TIME
max(eval(if(libelle="IN_BT", _time, null()))) as IN_BT_TIME
max(eval(if(libelle="OUT_BT", _time, null()))) as OUT_BT_TIME
max(eval(if(libelle="IN_RANG", _time, null()))) as IN_RANG_TIME
max(eval(if(libelle="OUT_RANG", _time, null()))) as OUT_RANG_TIME
by id_flux
| eval response=(OUT_PREC_TIME-IN_PREC_TIME) + (OUT_BT_TIME-IN_BT_TIME) + (OUT_RANG_TIME-IN_RANG_TIME)
| fields - *_TIME so you are collecting all the event times for each of the event types by flux id and then just calculating the response time at the end.