3 Replies Latest reply on Feb 21, 2018 4:27 AM by Ebbe Vig Nielsen

# Create a chart out of calculated data

Hi.

I'm fairly new with Tableau and ran into a problem that I couldn't figure out how to solve.

So I have a data set with some prices in EUR and prices in GBP on a lot of different days. What I did so far is create a simple sheet that then shows the % difference of the prices in the following format.

ArrivalDeparturePrice in EURPrice in GBP calculated to EUR% Difference
6. September 201814 September 2018519470-9,44%
6. September 201815 September 2018584525-10,10%
6. September 201816 September 2018649581-10,48%

Now what I would like to do is show a graph of the amount of times that the % difference is more than 10% or less than - 10%, so in the example above a chart saying that it happens 66,67% of the times.

Edit. Another thing that would be useful, if the graph is difficult to pull out would be a way to highlight the row if the difference is more than 10% or less than -10%

Any help to get me in the right direction would be appreciated

Ebbe.

Message was edited by: Ebbe Vig Nielsen

• ###### 1. Re: Create a chart out of calculated data

Hi Ebbe,

Find my approach stored in the attached workbook v10.3.

Let me know if this helps.

~Tushar

• ###### 2. Re: Create a chart out of calculated data

Hi, Ebbe

Hope this helps

ZZ

• ###### 3. Re: Create a chart out of calculated data

This is exactly what I want, and what I would do if the data was structured the way it's set up for you. The problem I have is that the way I'm retrieving the data is from 2 different feeds which I then combine. That means I don't have the EUR and GBP price in the same row. The example I gave was how the data looks like after I have made a sheet and combined the data.

The data I'm working with is structured in the following way

uid(The way I can combine the eur and gbp feeds), currency, start_date, end_date, price and discount.

So in the example I gave in the original post I have all ready done this calculation

And then calculated the % difference between the two prices.

I'm having troubles with this as the % calculation is generated from 2 rows and not 1, and is searching for ways to solve that.