-
1. Re: Create a chart out of calculated data
Tushar More Feb 21, 2018 2:49 AM (in response to Ebbe Vig Nielsen)-
EUR to GBP.twbx 18.4 KB
-
-
2. Re: Create a chart out of calculated data
Zhouyi ZhangFeb 21, 2018 3:04 AM (in response to Ebbe Vig Nielsen)
-
10% sample_v10.2.twbx 14.3 KB
-
-
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.