Can I calculate and display live currency value by using exchange price from external rest endpoint?

My data consists of transactions in different countries, stored in different currency. I want my dashboard to display those values using same currency, say USD. So I have to get the live exchange price from outside api, and multiply to all data for visualization. Is it possible? Thanks.

Hi @michaelcheung,

The recommended way is to have additional ingest step that will enrich your transaction data with USD field based on the rate at the transaction time/date before it's inserted into Elasticsearch.

Best,
Oleg

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