Wrike Analyze (Feature Request): Ability to calculate working days by excluding weekends and holidays

Hello!

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:

  1. 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. 
  2. 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.

Thank you!

Upvote 7
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
3 Kommentare

Christopher Halkovic Thanks a lot for submitting your ideas for Wrike Analyze! Passing it on to the Product team now 👍

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

I second this request...

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Welcome to the Community Mike Souder 👋 Thank you for supporting Christopher's suggestion! Please make sure to upvote (like) it too if you haven't done so yet as votes help our Product team estimate the amount of interest for different ideas 🙂

Lisa Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover

Lisa Wrike Team member Become a Wrike expert with Wrike Discover

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Wrike Analyze (Feature Request): Ability to calculate working days by excluding weekends and holidays
[this list is visible for admins and agents only]

Nach oben
Didn’t find what you were looking for? Write new post