This content has been marked as final. Show 2 replies
Hopefully this is easy. I have a table of sales data by date. I want to create a simple bar chart that shows the countries and the average sales price over the last seven days in USD, which requires currency conversions for multiple countries.
I will use a conversion rate pulled from Google Finance dynamically through a process I learned here (very cool).
The question is... How I can apply the exchange rate to the sales data without being able to create a relationship?
A couple of notes: 1- I am okay using the current exchange rate against the last 7 days of data, and 2- I don't know how to pull of table of historic exchange rates that connects properly to Tableau.