# I need to get top hits of scripted metric aggregation. can anyone suggest me how to do that?

**URL:** <https://discuss.elastic.co/t/i-need-to-get-top-hits-of-scripted-metric-aggregation-can-anyone-suggest-me-how-to-do-that/168936>\
**Category:** Elasticsearch\
**Created:** [February 19, 2019, 6:22am UTC](https://discuss.elastic.co/t/i-need-to-get-top-hits-of-scripted-metric-aggregation-can-anyone-suggest-me-how-to-do-that/168936 "2019-02-19T06:22:37Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nitin\_Kumar](https://avatars.discourse-cdn.com/v4/letter/n/c4cdca/32.png) [@Nitin\_Kumar](https://discuss.elastic.co/u/Nitin_Kumar)\
**Post date:** [February 19, 2019, 6:22am UTC](https://discuss.elastic.co/t/i-need-to-get-top-hits-of-scripted-metric-aggregation-can-anyone-suggest-me-how-to-do-that/168936/1 "2019-02-19T06:22:37Z")

</div>

here is my query  
{  
"size": 0,  
"query": {  
"nested": {  
"path": "items",  
"query": {  
"bool": {  
"must": [  
{  
"exists": {  
"field": "items"  
}  
}  
]  
}  
}  
}  
},  
"aggs": {  
"delayed\_m": {  
"scripted\_metric": {  
"init\_script": "params.\_agg.transactions = ",  
"map\_script": "params.max = 0; for(item in params.\_source.items){ if(item.deliveryLeadTime != null && item.deliveryLeadTime \> params.max){params.max = item.deliveryLeadTime }} params.delayed = ((params.\_source.expirationDate + 86400000) - params.max_24_60_60_1000 - new Date().getTime()) \< 0; params.\_agg.transactions.add(params.delayed)",  
"combine\_script": "params.sum = 0; for (max in params.\_agg.transactions) { if(max)params.sum += 1 } return params.sum",  
"reduce\_script": "params.sum =0; for(max in params.\_aggs){params.sum += max} return params.sum"  
}  
}  
}  
}

---

<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:** [March 19, 2019, 6:22am UTC](https://discuss.elastic.co/t/i-need-to-get-top-hits-of-scripted-metric-aggregation-can-anyone-suggest-me-how-to-do-that/168936/2 "2019-03-19T06:22:45Z")

</div>

Closed on March 19, 2019, 6:22am UTC

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