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:
- 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.
Thank you!
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
I second this request...
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
Curious if this has been rolled out yet? All of the data I need to report on will run into this issue.
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
Hi Lisa. Do we have a solution for this issue? I am also interested in using this type of metric. Thanks
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
Hi Lisa,
May I please also know the solution to this problem? I need to exclude weekends from my metric.
Thanks,
Scott
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 En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
Elaine Wrike Team member En savoir plus sur les fonctionalités et les meilleures pratiques grace à nos Webinaires online
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.
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
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!
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 👍
Are these available for business accounts yet?
Hi @... or Lisa
Is the solution here to calculating Working Days potentially shareable here?
-For a particular utilization report (we use a Custom Field on the Task set by API for Categories) we'd like to multiply hours (hardcoded value Ex. "8") by the amount of weekdays in a month.
Thanks!
cc: McKenna O'Leary & Ben Watts
Hi,
Is this feature available yet?
Thanks!
Hi Trevor Leslie, welcome to the Community! I'm afraid that there aren't any updates regarding this option at the moment.
Hello Ian Kizer, as not all cases refer to the same need, we pass the cases shared here on to our Analyze experts. I can see that our Support Team has assisted you with yours 🙂
Adding a +1 to this request. Please allow the option/ability to exclude holidays and weekends in Analyze.
Specifically, the Analytics "Task Status Change History Time Spent (Minutes)" calculation also includes weekends and holidays, contradicting Wrike's core fields info such as task or project duration which does not include weekends and holidays.
Hi Bo Samreth, thank you for chiming in! Thank you for sharing your feedback with us, I've passed it on to our Product Team 👍
Hi! I would like to exclude weekends on a few date automations that I have built recipes for. Can someone on the support team assist?
Hi Kirthana Kumar, welcome to the Community. I can see that you've been discussing your case with our Support Team. Did you receive the answer you were looking for?
Thank you!
Hi having the same issue. How do i exclude weekends from the DDIFF Calculation?
HI ALL,
For anyone interested i have come up with this to exclude weekends between two dates using ddiff.
(DDIFF([Days in Task Due Date],[Days in Task Start Date]))-(((DDifF([Days in Task Due Date],[Days in Task Start Date]))/7)*2)
Essentially i calculate the number of weeks between two dates and * by two to get the number of weekends. i take that number away from the original ddiff calculation. It is not exact as the there may be more weekends between two dates but its the best i could come up with.
Wrike are there any plans to add this functionality to the reports?