1 of 1 people found this helpful
I believe you're missing a date dimension that runs from 2013 to 2020 to be able to achieve what you want to do.
The only workaround I can think of is to export the data obtained by each year - meaning you move the parameter and extract the data in a excel file for each year. Then you put all the data in a single file while adding a new column that indicates the value of the parameter for that particular data. (so for the extract you did when the parameter was in 2013, then you put 2013 under that column for the data obtained)
Then you reopen Tableau with the new data and you'll have your new data dimension to achieve the graph you want to display.
This is what I thought... And a table formatted as following won't work either :
2014 2015 2016 2017 2018
15.000 m² 15.000 m²
25.000 m² 25.000 m² 25.000 m² 25.000 m² 25.000 m²
43.000 m² 43.000 m² 43.000 m²
10.000 m² 10.000 m² 10.000 m² 10.000 m² 10.000 m²
30.000 m² 30.000 m² 30.000 m² 30.000 m²
Because tableau won't be able to use the date as a single dimension...
This means that I would have to transform this table to a much more complex one with a single row for each year contract and every year to analyze :
B 15.000 m² 2013 B 15.000 m² 2013 ... ... ...
An so on for each contract and each projected year... As the main data must be adapted quite often (with new details for each contract), this seems not useable without a good ETL tool that would make such transformation automatic.
Thanks for the insight !