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 16
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
13 comentários

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

3
👍 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

Curious if this has been rolled out yet?  All of the data I need to report on will run into this issue.  

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

Hi Austin Seabert, welcome to the forums 🙂 

I can see you've discussed this with our Wrike Analyze experts from the Support team. Anything else you need help with - please let me know 🙌

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

Hi Lisa. Do we have a solution for this issue? I am also interested in using this type of metric. Thanks

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

Hey Luisa de La Vega Bayma de Oliveira, welcome to the forums 👋 I've asked our experts to reach out to you too 👍

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

Hi Lisa,

May I please also know the solution to this problem? I need to exclude weekends from my metric.

Thanks,

Scott

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

Hey Scott Stanelle, thanks for getting in touch. 

I've raised a ticket for you now and our team will be in touch shortly to assist 👍

Elaine Community Team at Wrike Wrike Product Manager Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

Elaine Wrike Team member Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

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

I've got the same challenge when trying to work out completion times. All the hours being pulled is including weekends which throws out my figures.

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

Welcome to the Community Brett Beagley 👋 Thanks for reaching out!

I've now asked our Wrike Analyze experts to reach out to you about this, someone will be in touch soon.

Do let me know if you need help with anything else 🙂

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

If there has been a solution created for this need please let me know for we are in need of this feature as well. Thank you!

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

Hi Alonzo Barahona, welcome to the Community! Thank you for your comment, I've created a ticket with our Support Team on your behalf and one of our experts will reach out to you very soon to assist you with this 👍

Juan Community Team at Wrike Wrike Product Manager Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

Juan Wrike Team member Aprenda sobre as funcionalidades e melhores práticas em Wrike com o nosso Treinamento Webinar Online

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]

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