Best way of applying a currency transformation to a field

Elastic Stack Kibana
1

Hi
I have a visualization where I count the amount of orders for the product, and I want to know the valorization of the amount, but the orders are done in multiple currency so want them to be converted into one by example in $.
Do you have a best practice on the way of making this transformation?

Thanks and regards

2

Hey @GregoryB-T, it's going to be more performant to perform this transformation before inserting your documents into Elasticsearch. However, if this isn't feasible, you could potentially use a scripted field to perform this transformation.

3

HI @Brandon_Kobel ,

Thanks, I think it will be possible to do it before inserting the documents. may be at logstash level.

Regards.