I am newbie to elastic/kibana and i am stuck with a problem.
I have transactional records in which multiple currency types are used like
doc - 1
Amount : 500
Currency : USD
Amount : 100
Currency : CAD
In Kibana, i want to display the sum of the amount in USD.
I thought about adding a new index with the currency-exchange rate mapping and then join it with transaction index as we do in RDBMS, but it is not possible in elastic.
What is the best possible way to do this ?
Thank you for your help