While building some of our first Wrike Analyze reports, we've come across some features that we think are crucial to capturing accurate data and wanted to submit it here.
Problem: We need the ability to build a report that shows the number of business (working) days a set of project took to complete. While the DDIFF function allows us to calculate the difference between the date of creation and the date of completion of a project, it does not exclude weekends or holidays thus leaving the number higher than it should be.
Current workaround: While not accurate, we can multiply the formula DDiff([Days in Project Completion Date],[Days in Project Creation Date]) by (5/7) if the value is greater than 7 to get a closer number.
Ideas for solution:
- Determine if there is a way to add some filter functionality that could exclude weekends and exclude holidays set in your account work schedule within formulas.
- Our guess is that this number would be very important for multiple Wrike customers, so Wrike could simply add this to the Data Browser as a value part of the Project data. For instance, we have duration of tasks, but this could calculate the duration of the project based on the start date and due date of the project and exclude dates set in your work schedule as well as weekends.
I'm sure there are a few other solutions, but thought it best to list some.