Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

322
Views
ElasticSearch - Get count of documents for each aggregation value that matches a condition (LTE of each value)
Goal

For each value from a terms aggregation, get the count of documents that abide to the condition of lte to that value.

My query:
{
  ...
  "aggs": {
    "all_values": {
      "terms": {
        "field": "characteristics.values.value" //for each of these values
      }
    }
  },
  "nested": {
    "path": "characteristics.values"
  }
}

Note: The characteristics.values.value is a keyword, so I will somehow have to use a script or some other approach to convert it to numeric/interger. I cannot change it from keyword as the code generating the query is generic for other queries as well.

With scipt, it should be something like this?:

"source": "Float.parseFloat(doc['characteristics.values.value'].value).value"
about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!