I've done this in the earlier versions of elasticsearch by simply converting the identical field (chargeamount) within the aggs tag which looks like this: { "query":{ "query_string":{ "query":"api:\"payment\" AND transactionoperationstatus:\"charged\"AND year:2016 AND month:…

Converting a string value into a double in Elasticsearch 5.0.0

Topic		Replies	Views
Painlessly turning a string of multiple numbers into multiple fields of numbers Elasticsearch painless , language-clients , runtime-fields	3	982	March 31, 2023
If the numbers after the decimal is zero, it doesn't return as a double value? Elasticsearch	3	897	July 5, 2017
ES 5.6.10 default mapping field store Double and BigDecimal into string Elasticsearch	1	436	November 28, 2019
Field is of type string when doing search when mapping specifies double Elasticsearch	5	1046	March 23, 2017
Double datatypes values returned as 0 rather than 0.0 in Elastic Search Results Elasticsearch	17	3387	February 8, 2018