Perform filter on 2 different fields at the same time

Hi there,

Here's what I would like to achieve :

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.

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:

1 Like

Thanks a lot ! It worked ! :slight_smile:

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.