as you can see on the screenshot below. Its values should match the currency symbols (EUR, GBP, etc although you are welcome to give the long names for the display aliases. Installing prerequisites: TabPy, if have you never used TabPy before, you can download TabPy Server here and find the official installation instructions here or an even more detailed one provided by the community here. I brought down the conversion rates for EUR and GBP from m ( heres an example ideally youd be keeping the exchange rates in a woher kommen marktschwankungen forex table in your database and have a process for keeping them up to date. The essence of the solution is to join in an exchange rates table to your data. Once you have TabPy up and running install Forex Python using the following command: pip install forex-python or download it from github and copy the Forex Python library to And we are done with all the installing and configuring, now lets get to the fun. The main thing to remember with exchange rates is that they change over time, and therefore need to be stored with a Date field. Now the price needs to multiply against the quantity for the adjusted sales. In a new series of blog posts, what I creatively named as Python Experiments in Tableau, I will share a few projects that we are doing in-house to play with Python and Tableau. Weve always been a bit Anglo-centric, so our sales to Great Britain are equivalent to those in the rest of the European Union.
Introduction Whether youre a power trader or a financial newbie, youre likely to hear just about anythingmarket movements, outlooks and stocksbeing described as bullish or bearish.
Tableau, server was probably suggested to you because it allows you to run a report but pass values into the report dynamically by way of something called a Parameter.
The values in question could be your conversion factors.
Once you have TabPy up and running install.
You'd essentially have a URL which passes this info into Tableau Server. Hi Nate, unless your conversion factors are already stored in a database somewhere and Tableau is connected "live" to that database, you're in a bit of a pickle. Here comes the magic, where we can start using the TabPy and Forex Python. The rates are updated daily 3PM CET. Tableau Server was probably suggested to you because it allows you to run a report but pass values into the report dynamically by way of something called a "Parameter". To do this, I need a currency conversion table. First, we will initialize the CurrencyRates class from forex_nverter, so we can work with the currency rates, then we call the get_rate function with two arguments, where the first argument is the source currency and the second is the target currency, to convert the. You'd still need to go out and grab the values from the source of your choice, but then you could provide them to Tableau Server when you ask it to render a report, and they could be used like this: IF Country"United Kingdom" then 2012. Add live currency conversion to Tableau Dashboards using TabPy. If you are using extracts, none of this can be pre-calculated anyway because of the parameters flexibility, so its doubtful that there are performance differences between the different calculations you might write.