How I can get 2 fields values in Elastic Search

[Tortoise]

Hello @SivaK

You will have to create a runtime field from this .keyword field if you want to perform sum on keyword fields.

Similar post :

Can I do a sum on the fields that have 'keyword' type

I have a field that is keyword type. The index looks like this: { "key": 1 }, { "key": 2 }, { "key": 3 }, { "key":"abc" }, { "key":"zyx" } Some values are numeric and some are strings. Is there a way to sum all numeric keywords such that the value comes to 1+2+3 = 6 Is some form type casting possible?

Thanks!!