Hello,
I plan to compare actual time and planned time in line chart.
For now, the model works well with our actual working time, which is updated daily.
But we want a planned time added in, to show the difference between cumulative actual time spent and planned time.
The problem is, we plan time weekly, not daily. So the query data only record our planned time on the last day of our week. So for now, our planned cumulative time only shows a dot on the last workday, rather than demestrate as a line.
(P.S. our company's last workday is Thursday, rather than Friday, I have convert the natual week and day into our company's work calendar)
Could anybody help us to divide our weekly planned time evenly into daily, then cumulate them into weekly, to compare with daily cumulative actual time?
shared file is here:
Actual VS Est
Many tks~
