I was asked to create a query for records with response times in range between 10th and 90th percentile. These data are in single numeric field in documents.
I know I can get both of them with aggregation query, but I need to get value of range (90-10)th percentile and I was wondering if that is at all possible in single query without need of performing any additional computations on results.
with something like this:
I'm getting two separate series of data instead of one, which I'm aiming for.