How to add the reference line that changes overtime?
The dimension is project released month from 09/2018 to 01/2019.
My target is 09/2018: 66%; 10/2018: 99%; 11/2018: 100%; 12/2018: 100%; 01/2019: 100%.
I wrote a load * inline statement to insert two more column in my data. But the target number is not showing in my final table at all.
Name, [Project Development Release Month] FROM a location (qvd); left join(Table1) load * inline [Project Development Release Month, Target 09/2018,66% 10/2018,100% 11/2018,100% 12/2018,100% 01/2019,100%];