We are migrating our internal datastore to druid and in order to reach feature parity we need to implement some sort of currency conversion. I would like to explain the feature we are trying to implement and I would like to get recommendation if our way to implement is the correct one. In our data that we inject to druid we have revenues in a reference currency, for instance eur. However we offer to our customer the capability to see data in any currency by applying exchange rates as given by the European Central Bank. This is an example of data we have already right now in druid
I want to be able to do a query where I group by Site and I see revenues for example in USD. Therefore assuming that on 20170101 we had a factor of 1.08 and on 20170102 we had 1.05 and on 20170103 we had 1.07 as final result I will get
Thank you very much for your support.