# How to use Max Aggregation value in Filter Aggregation

**URL:** <https://discuss.elastic.co/t/how-to-use-max-aggregation-value-in-filter-aggregation/80952>\
**Category:** Elasticsearch\
**Created:** [April 3, 2017, 7:12am UTC](https://discuss.elastic.co/t/how-to-use-max-aggregation-value-in-filter-aggregation/80952 "2017-04-03T07:12:25Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![prashant.bajpai](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant.bajpai/32/16844_2.png) [@prashant.bajpai](https://discuss.elastic.co/u/prashant.bajpai)\
**Post date:** [April 3, 2017, 7:12am UTC](https://discuss.elastic.co/t/how-to-use-max-aggregation-value-in-filter-aggregation/80952/1 "2017-04-03T07:12:25Z")

</div>

I need to use the Max aggregation value, See below query.

```
              "aggregations":{

                    "maxValue": {
                       "max": {
                         "field": "value"
                       }
                    },
                    "result" : {
                      "filter": {
                        "script": {
                          "script": {
                            "inline": "valueParam> 50 && valueParam< 100",
                            "params": {
                              "valueParam" : "maxValue"
                            }
                          }
                        }
                      }
                    }

                }

```

I am not able to execute query like above.  
Please suggest how can I use Max aggregation value in other aggregations?  
Thanks

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [April 3, 2017, 8:03am UTC](https://discuss.elastic.co/t/how-to-use-max-aggregation-value-in-filter-aggregation/80952/2 "2017-04-03T08:03:17Z")

</div>

Have a look at [https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/search-aggregations-pipeline.html)

---

<div class="post-metadata">

**Author:** ![prashant.bajpai](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant.bajpai/32/16844_2.png) [@prashant.bajpai](https://discuss.elastic.co/u/prashant.bajpai)\
**Post date:** [April 3, 2017, 9:45am UTC](https://discuss.elastic.co/t/how-to-use-max-aggregation-value-in-filter-aggregation/80952/3 "2017-04-03T09:45:58Z")

</div>

Thanks for your quick response,, I am trying but still no success. ☹ Can you please provide me any example by using the max aggregation value in filter aggregation script, as I mentioned in question ?

I have tried like above but getting exception:

```
    "reason": {
                   "type": "script_exception",
                   "reason": "failed to run inline script [valueParam> 50 && valueParam< 100] using lang [groovy]",
                   "caused_by": {
                      "type": "class_cast_exception",
                      "reason": "java.lang.Integer cannot be cast to java.lang.String"
                   }
                }
```

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [April 3, 2017, 10:24am UTC](https://discuss.elastic.co/t/how-to-use-max-aggregation-value-in-filter-aggregation/80952/4 "2017-04-03T10:24:18Z")

</div>

Are you using an old version of elasticsearch?

---

<div class="post-metadata">

**Author:** ![prashant.bajpai](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant.bajpai/32/16844_2.png) [@prashant.bajpai](https://discuss.elastic.co/u/prashant.bajpai)\
**Post date:** [April 3, 2017, 11:50am UTC](https://discuss.elastic.co/t/how-to-use-max-aggregation-value-in-filter-aggregation/80952/5 "2017-04-03T11:50:59Z")

</div>

I am using "2.3.2"

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [April 3, 2017, 5:09pm UTC](https://discuss.elastic.co/t/how-to-use-max-aggregation-value-in-filter-aggregation/80952/6 "2017-04-03T17:09:38Z")

</div>

Try with `"valueParam" : maxValue` instead of `"valueParam" : "maxValue"`

---

<div class="post-metadata">

**Author:** ![prashant.bajpai](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/prashant.bajpai/32/16844_2.png) [@prashant.bajpai](https://discuss.elastic.co/u/prashant.bajpai)\
**Post date:** [April 4, 2017, 4:18am UTC](https://discuss.elastic.co/t/how-to-use-max-aggregation-value-in-filter-aggregation/80952/7 "2017-04-04T04:18:12Z")

</div>

When I use -\> "valueParam" : maxValue

```
"reason": {
               "type": "json_parse_exception",
               "reason": "Unrecognized token 'maxValue': was expecting ('true', 'false' or 'null')\n at [Source: [B@bff38e; line: 111, column: 53]"
            }

```

When I use-\> "valueParam" : "maxValue"

```
"reason": {
               "type": "script_exception",
               "reason": "failed to run inline script [valueParam > 50 && valueParam< 100] using lang [groovy]",
               "caused_by": {
                  "type": "class_cast_exception",
                  "reason": null
               }
            }
```

---

<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:** [May 2, 2017, 4:18am UTC](https://discuss.elastic.co/t/how-to-use-max-aggregation-value-in-filter-aggregation/80952/8 "2017-05-02T04:18:11Z")

</div>

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