# How to get the Greater or Last Value in a Document for doing filter

**URL:** <https://discuss.elastic.co/t/how-to-get-the-greater-or-last-value-in-a-document-for-doing-filter/300246>\
**Category:** Kibana\
**Created:** [March 21, 2022, 7:33pm UTC](https://discuss.elastic.co/t/how-to-get-the-greater-or-last-value-in-a-document-for-doing-filter/300246 "2022-03-21T19:33:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vthiyagarajan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vthiyagarajan/32/103320_2.png) [@vthiyagarajan](https://discuss.elastic.co/u/vthiyagarajan)\
**Post date:** [March 21, 2022, 7:33pm UTC](https://discuss.elastic.co/t/how-to-get-the-greater-or-last-value-in-a-document-for-doing-filter/300246/1 "2022-03-21T19:33:50Z")

</div>

I have a JSON document like this  
{  
"EmpDetails" : {  
"emplid" : "32444"  
"sickdays" : "3"  
"batch\_id": "22-04"  
},  
"EmpDetails" : {  
"emplid" : "32445"  
"sickdays" : "3"  
"batch\_id": "22-04"  
},  
"EmpDetails" : {  
"emplid" : "32446"  
"sickdays" : "3"  
"batch\_id": "22-04"  
},  
"EmpDetails" : {  
"emplid" : "32444"  
"sickdays" : "3"  
"batch\_id": "22-05"  
},  
"EmpDetails" : {  
"emplid" : "32445"  
"sickdays" : "3"  
"batch\_id": "22-05"  
},  
"EmpDetails" : {  
"emplid" : "32446"  
"sickdays" : "3"  
"batch\_id": "22-05"  
},  
}

I am trying to create a filter by getting the max batch id, it can go from 22-01 to 22-12 and it is a text field

---

<div class="post-metadata">

**Author:** ![Marta\_Bondyra](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marta_bondyra/32/102122_2.png) [@Marta\_Bondyra](https://discuss.elastic.co/u/Marta_Bondyra)\
**Post date:** [March 23, 2022, 7:43am UTC](https://discuss.elastic.co/t/how-to-get-the-greater-or-last-value-in-a-document-for-doing-filter/300246/2 "2022-03-23T07:43:51Z")

</div>

Unfortunately, at the moment it's not possible. Here's the detailed answer: [Extract Max value of build number from result and use it in filter value - #2 by Ajinkya\_Sabale](https://discuss.elastic.co/t/extract-max-value-of-build-number-from-result-and-use-it-in-filter-value/103864/2)

---

<div class="post-metadata">

**Author:** ![vthiyagarajan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vthiyagarajan/32/103320_2.png) [@vthiyagarajan](https://discuss.elastic.co/u/vthiyagarajan)\
**Post date:** [March 25, 2022, 4:53pm UTC](https://discuss.elastic.co/t/how-to-get-the-greater-or-last-value-in-a-document-for-doing-filter/300246/3 "2022-03-25T16:53:05Z")

</div>

Thanks Marta. Unfortunately can't apply a default filter on a text by doing a substring or something has to be addressed..

---

<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:** [April 22, 2022, 4:53pm UTC](https://discuss.elastic.co/t/how-to-get-the-greater-or-last-value-in-a-document-for-doing-filter/300246/4 "2022-04-22T16:53:51Z")

</div>

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