2 Replies Latest reply on Aug 17, 2018 3:42 PM by Kevin Pratt

    Unrelated data source

    Kevin Pratt

      Hi all,

       

      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.

       

      Thanks

      Kevin