Perform filter on 2 different fields at the same time

[didinyah (Didi)]

Hi there,

Here's what I would like to achieve : https://imgur.com/a/fRfeW

I want to recover the red values by applying filters (or with a query).

I want to get the earliest startTime when the operation is "Attente" and I want to get the latest startTime when the operation is "Validé". Is there a way to do this filter with kibana or with an elasticsearch query ? I tried to do some queries but they must be wrong since I have no results...

Thanks for your help.

[Stacey_Gammon]

I think you can do this using two different visualizations and using a Min or a Max value on the startTime.

Would something like this work for you?

My final visualizations on a dashboard:

How the min start time one is set up:

Max one:

All my data:

[didinyah (Didi)]

Thanks a lot ! It worked !