Currency Conversion on the fly[ Edited ]
May 2017 - last edited May 2017
The base currency on my website is US$ and that's what gets reported in Google Analytics (which is my data source for Data Studio).
I would however like all the reports to display Revenue numbers NZ$.
Is there a way in Data Studio to do a conversion based on an exchange rate feed?
I have created a custom metric that multiplies the Revenue metric by the current exchange rate but I would love not to have to change it manually. :-)
Currency Conversion on the fly
I'm hoping that down the road Data Studio would introduce something similar to a 'Parameter' in Tableau where each Parameter Selection (via dropdown menu) could be tied to a different calculation/definition. This would allow functionality where each "Parameter" option, for example, would result in = (Metric * Parameter Value) and then any number of calculations could be performed, in this case the user defines each option to be based on currency valuations.