Check how much progress the project was on a specific date
Hey guys!
I calculated the progress of the projects, based on the total count of completed tasks over the total number of tasks.
(COUNT([Task ID]),[Task Completed],[Task Workflow]) / (COUNT([Task ID]),[Task all statuses],[Task Workflow])
If I choose a previous date, the progress will always be the current one and not the selected date. However, there is a need to see this percentage over time, that is, if I want to view the progress of a project on a specific date, I would like it to show the progress that was on that date and not the current progress. Are there any ways to visualize the progress of the project over time? For example, if on 01/07 it was at 76% and now on 10/07 it is 93%, if I chose the date of 01/07 on the calendar, I would like to see the percentage of 76%.
Does that possibility exist?