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

Create a chart out of calculated data

Ebbe Vig Nielsen Feb 21, 2018 2:35 AM

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.

Arrival	Departure	Price in EUR	Price in GBP calculated to EUR	% Difference
6. September 2018	14 September 2018	519	470	-9,44%
6. September 2018	15 September 2018	584	525	-10,10%
6. September 2018	16 September 2018	649	581	-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

Tushar More Feb 21, 2018 2:49 AM (in response to Ebbe Vig Nielsen)
Hi Ebbe,

Find my approach stored in the attached workbook v10.3.
Let me know if this helps.

~Tushar

EUR to GBP.twbx 18.4 KB
Like Show 0 Likes(0)

Actions
2. Re: Create a chart out of calculated data

Zhouyi Zhang Feb 21, 2018 3:04 AM (in response to Ebbe Vig Nielsen)
Hi, Ebbe

Please find my solution attached.

Hope this helps

ZZ

10% sample_v10.2.twbx 14.3 KB
Like Show 0 Likes(0)

Actions
3. Re: Create a chart out of calculated data

Ebbe Vig Nielsen Feb 21, 2018 4:27 AM (in response to Tushar More)

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.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Create a chart out of calculated data

1. Re: Create a chart out of calculated data

2. Re: Create a chart out of calculated data

3. Re: Create a chart out of calculated data

Actions

More Like This