# Arithmetic operations on count result **URL:** \ **Category:** Kibana\ **Created:** [June 6, 2016, 2:48pm UTC](https://discuss.elastic.co/t/arithmetic-operations-on-count-result/51958 "2016-06-06T14:48:25Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jeremyr](https://avatars.discourse-cdn.com/v4/letter/j/df705f/32.png) [@jeremyr](https://discuss.elastic.co/u/jeremyr)\ **Post date:** [June 6, 2016, 2:48pm UTC](https://discuss.elastic.co/t/arithmetic-operations-on-count-result/51958/1 "2016-06-06T14:48:25Z")
Hi All, I'm new to kibana ( Kibana 4.5) and I would like to know, if there a way to apply a simple math operation on count result like multiplication or division. I tried to add a script\_fields on JSON input by following the documentation but it does not work... My goal is to multiply this result ( see Example below) ![](https://us1.discourse-cdn.com/elastic/original/2X/6/6a02accc465ec8f8a05324b9f8874723d6e23458.JPG) Thanks for your help. J. ---
**Author:** ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)\ **Post date:** [June 9, 2016, 5:48pm UTC](https://discuss.elastic.co/t/arithmetic-operations-on-count-result/51958/2 "2016-06-09T17:48:37Z")
If you wanted to say, multiply the count by two. One way to accomplish this would be to use a scripted field. In Settings \> Indices \> Scripted Fields create a new field with the script simply being "2". You can then create a metric to SUM the new scripted field. ---
**Author:** ![jeremyr](https://avatars.discourse-cdn.com/v4/letter/j/df705f/32.png) [@jeremyr](https://discuss.elastic.co/u/jeremyr)\ **Post date:** [June 10, 2016, 6:33am UTC](https://discuss.elastic.co/t/arithmetic-operations-on-count-result/51958/3 "2016-06-10T06:33:54Z")
I am able to multiply a numeric field with this script : _doc['numeric\_field'].value \* 2_ but my goal is to multiply a count result query ( with a non-numeric field) eg: Multiply unique count of client\_id ( client\_id is not a numeric document) _Visualize: Field [client\_id] used in expression must be numeric_ I'm not sur if we can do this with Kibana right now. Thanks. J. ---
**Author:** ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)\ **Post date:** [June 10, 2016, 6:42am UTC](https://discuss.elastic.co/t/arithmetic-operations-on-count-result/51958/4 "2016-06-10T06:42:14Z")
Try setting the script to "2", then using SUM instead of COUNT ---
**Author:** ![bharat](https://avatars.discourse-cdn.com/v4/letter/b/5fc32e/32.png) [@bharat](https://discuss.elastic.co/u/bharat)\ **Post date:** [June 17, 2016, 6:50pm UTC](https://discuss.elastic.co/t/arithmetic-operations-on-count-result/51958/5 "2016-06-17T18:50:11Z")
Did you tried in JSONInput like this {"script":"\_value\*2"} to multiply the output?(in this case to get 2 times the Unique count of ClientId ) ---
**Author:** ![Dan\_AdWorks](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@Dan\_AdWorks](https://discuss.elastic.co/u/Dan_AdWorks)\ **Post date:** [June 18, 2016, 5:05pm UTC](https://discuss.elastic.co/t/arithmetic-operations-on-count-result/51958/6 "2016-06-18T17:05:34Z")
wow, great recommendation really helped me. what else can be done with the json script? ---
**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, 1:50pm UTC](https://discuss.elastic.co/t/arithmetic-operations-on-count-result/51958/7 "2017-07-06T13:50:02Z")