Forum Discussion
Date relationship not working / plotting multiple lines vs. dates
I would like to plot normalized work progress and hours used on a single axis, as follows: I have a general table with project information that is related to two further tables that contain th...
I recommend you set up a Date table with continuous dates covering the range of dates in the model. You can then also use Time Intelligence functions
Thanks, I set this up and I feel this is the right approach, but there is a new problem:
On the upper graph I plotted work progress (0...1) vs the newly set-up date table (red line), which shows correctly. The % hours used (dark blue) are displayed wrong vs the new date table. There is a factor 100 between the displayed and the calculated value and the order of the values linked to the new date table is wrong.
The lower graph shows the correct data of % hours used vs. the old date in the table.
Maybe you can see where I went wrong.