# Alternative lucene query to implement rate() function in elasticsearch

**URL:** <https://discuss.elastic.co/t/alternative-lucene-query-to-implement-rate-function-in-elasticsearch/249143>\
**Category:** Elasticsearch\
**Created:** [September 18, 2020, 5:02pm UTC](https://discuss.elastic.co/t/alternative-lucene-query-to-implement-rate-function-in-elasticsearch/249143 "2020-09-18T17:02:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sankpra34](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sankpra34/32/48265_2.png) [@Sankpra34](https://discuss.elastic.co/u/Sankpra34)\
**Post date:** [September 18, 2020, 5:02pm UTC](https://discuss.elastic.co/t/alternative-lucene-query-to-implement-rate-function-in-elasticsearch/249143/1 "2020-09-18T17:02:59Z")

</div>

I need to convert my PromQL query from my Grafana dashboard into Elasticsearch supported Lucene's query. Currently, there is no such function that can be used as rate() function. Is there any way to implement rate() functionality of Prometheus DS into Elasticsearch.

PromQL query for reference:

`sum (rate (container_cpu_system_seconds_total{namespace=~"$Namespace"}[5m]))`

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [September 21, 2020, 11:59am UTC](https://discuss.elastic.co/t/alternative-lucene-query-to-implement-rate-function-in-elasticsearch/249143/2 "2020-09-21T11:59:45Z")

</div>

The next minor version of the Elastic Stack will likely have support for a [rate aggregation](https://www.elastic.co/guide/en/elasticsearch/reference/7.x/search-aggregations-metrics-rate-aggregation.html) and this github issue [https://github.com/elastic/elasticsearch/issues/60674](https://github.com/elastic/elasticsearch/issues/60674)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 19, 2020, 11:59am UTC](https://discuss.elastic.co/t/alternative-lucene-query-to-implement-rate-function-in-elasticsearch/249143/3 "2020-10-19T11:59:48Z")

</div>

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