Elasticsearch query to get count of current hour and last hour documents

Question

I need to get a count of the current hour document and also last one hour from current hour and as well fetch only records for current hour

let's consider now it is "2023-06-26 20:44:56"

I need to fetch records which have timestamp greater than "2023-06-26 20:44:56" and as well get the count of documents within last hour i.e "2023-06-26 19:44:56" to "2023-06-26 20:44:56"

"query": {
              "bool": {
                  "must": [
                      {
                          "range": {
                              "timestamp": {
                                  "gte": "2023-06-26 20:44:56"
                              }
                          }
                      }
                  ]
              }
          },
          "sort": [
              {
                  "timestamp": {
                      "order": "asc"
                  }
              }
          ],
          "aggs": {
              "last_hour_count": {
                  "range": {
                      "field": "timestamp",
                      "ranges": [
                          {
                              "from": "2023-06-26 19:44:56",
                              "to": "2023-06-26 20:44:56"
                          }
                      ]
                  }
              }
          }

I have used bool because there are other conditions as well This query is not giving the count for the last hour can someone please help

Instead of trying to solve this in one query. I am using two quries. — Srujan Gundeti, Jun 27 '23 at 12:51
Do you mean you need to retrieve the count for the past 2 hours, rounded to the hour? — superstienos, Jun 28 '23 at 08:54

Elasticsearch query to get count of current hour and last hour documents

0 Answers0