# Best way of applying a currency transformation to a field

**URL:** https://discuss.elastic.co/t/best-way-of-applying-a-currency-transformation-to-a-field/135563
**Category:** Kibana
**Created:** [June 12, 2018, 3:11pm UTC](https://discuss.elastic.co/t/best-way-of-applying-a-currency-transformation-to-a-field/135563 "2018-06-12T15:11:45Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![GregoryB-T](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gregoryb-t/32/28564_2.png) [@GregoryB-T](https://discuss.elastic.co/u/GregoryB-T)
#### Post date: [June 12, 2018, 3:11pm UTC](https://discuss.elastic.co/t/best-way-of-applying-a-currency-transformation-to-a-field/135563/1 "2018-06-12T15:11:46Z")

</div>

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

---

<div class="post-metadata">

### Author: ![Brandon\_Kobel](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/brandon_kobel/32/14829_2.png) [@Brandon\_Kobel](https://discuss.elastic.co/u/Brandon_Kobel)
#### Post date: [June 13, 2018, 10:45am UTC](https://discuss.elastic.co/t/best-way-of-applying-a-currency-transformation-to-a-field/135563/2 "2018-06-13T10:45:02Z")

</div>

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](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html) to perform this transformation.

---

<div class="post-metadata">

### Author: ![GregoryB-T](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/gregoryb-t/32/28564_2.png) [@GregoryB-T](https://discuss.elastic.co/u/GregoryB-T)
#### Post date: [June 15, 2018, 9:17pm UTC](https://discuss.elastic.co/t/best-way-of-applying-a-currency-transformation-to-a-field/135563/3 "2018-06-15T21:17:11Z")

</div>

HI @Brandon_Kobel ,

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

Regards.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 13, 2018, 9:17pm UTC](https://discuss.elastic.co/t/best-way-of-applying-a-currency-transformation-to-a-field/135563/4 "2018-07-13T21:17:15Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.