# Metric aggregations: how to divide value and Courier of shard failed **URL:** \ **Category:** Kibana\ **Created:** [August 19, 2015, 4:31am UTC](https://discuss.elastic.co/t/metric-aggregations-how-to-divide-value-and-courier-of-shard-failed/27630 "2015-08-19T04:31:23Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Jason\_Zheng](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jason_zheng/32/4041_2.png) [@Jason\_Zheng](https://discuss.elastic.co/u/Jason_Zheng)\ **Post date:** [August 19, 2015, 4:31am UTC](https://discuss.elastic.co/t/metric-aggregations-how-to-divide-value-and-courier-of-shard-failed/27630/1 "2015-08-19T04:31:23Z")
Hi All, is it possible to divide some key vaule in Metric aggregations as following, I would like to divide 'ismb.miki.host.ram.usage" with an number in percentile ![](https://us1.discourse-cdn.com/elastic/original/2X/4/43142de5b96f95979c2bc9a3a5819f8c05569668.png) I found an issue and follow that steps, and then create a scripted field as following ![](https://us1.discourse-cdn.com/elastic/original/2X/0/0927c45e35ba66818380e73f30fa08fd61b317b5.png) Then I create a visualization by Metric, set average to aggregations and set my custom scripted filed to field, but some warning displayed as following ![](https://us1.discourse-cdn.com/elastic/original/2X/a/a9559e9668bdd434be65e0f800d63d0874e87129.png) To solve the problem I refer to [https://github.com/elastic/kibana/issues/3221](https://github.com/elastic/kibana/issues/3221) to increase thread search queue\_size in elasticsearch.yml (every node) ``` ##### Thread pool ##### # Search pool threadpool.search.type: fixed threadpool.search.size: 200 threadpool.search.queue_size: 20000 ``` Did I misunderstand something?? Please someone help Jason ---
**Author:** ![Jason\_Zheng](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jason_zheng/32/4041_2.png) [@Jason\_Zheng](https://discuss.elastic.co/u/Jason_Zheng)\ **Post date:** [August 20, 2015, 9:45am UTC](https://discuss.elastic.co/t/metric-aggregations-how-to-divide-value-and-courier-of-shard-failed/27630/2 "2015-08-20T09:45:42Z")
Anyone can help? ---
**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\ **Post date:** [August 20, 2015, 9:23pm UTC](https://discuss.elastic.co/t/metric-aggregations-how-to-divide-value-and-courier-of-shard-failed/27630/3 "2015-08-20T21:23:47Z")
Not currently. We have upcoming experimental functionality in Kibana 4.2 that would be helpful in such a scenario, but this is not currently possible in 4.1. ---
**Author:** ![Jason\_Zheng](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jason_zheng/32/4041_2.png) [@Jason\_Zheng](https://discuss.elastic.co/u/Jason_Zheng)\ **Post date:** [August 21, 2015, 1:58am UTC](https://discuss.elastic.co/t/metric-aggregations-how-to-divide-value-and-courier-of-shard-failed/27630/4 "2015-08-21T01:58:53Z")
Hi Tanya, Thanks for replying Another question is "Courier of shard filed" warning (or error?), shall this question post here or elasticsearch topic? Jason ---
**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\ **Post date:** [August 21, 2015, 3:44am UTC](https://discuss.elastic.co/t/metric-aggregations-how-to-divide-value-and-courier-of-shard-failed/27630/5 "2015-08-21T03:44:41Z")
Hey Jason - Yeah, I'm not sure. Better ask directly in Elasticsearch 🙂 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:14pm UTC](https://discuss.elastic.co/t/metric-aggregations-how-to-divide-value-and-courier-of-shard-failed/27630/6 "2017-07-06T14:14:26Z")