What can we help you with?

e.g. Gantt chart, Creating tasks, Sharing folders

Reporting: Created to completed duration

4 comments

  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Parker Sorensen

    In reports, you can actually create calculated fields. I think this is a pretty new feature. Here's how it works:

    - Go to your report where you want the Created to Completed Duration metric

    - Click on the cog at the top left of the screen to select which columns to display (see image below). 

    - Under the Calculated FIelds, click "Create field". That will bring up a box that looks like this: 

    - In this box, add a Name to the metric, and then add the following formula: "[Completed date] - [Created date]"

    - Hit save. This should then appear on your report. If you need to make edits, you can click on the dropdown arrow on the column header:

     

     

    Hope this is helpful! Good luck!

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Parker Sorensen

    I just realized this is part of Wrike Labs, so to use this feature, you would need to enable it here: https://www.wrike.com/labs/

    Is this helpful? 0
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Kristel Nubla-Watts

    This is actually super helpful! I just enabled this feature from labs and works great.

    Would you happen to know if this calculates working/non-working days (like the weekends) - I'm comparing that from an excel field/calculation but it seems I'm off a bit.

    Thank you!

    Is this helpful? 1
    Comment actions Permalink
  • Spot On! 👍 Innovative Approach 💡 Stellar Advice 💪
    Avatar
    Parker Sorensen

    I'm glad it was helpful!

    I'm not sure about that. I assume that it would count all days, regardless of it they are weekends/holidays/days off. There might be a way to add to the formula to exclude days off? Not sure though.

    Is this helpful? 0
    Comment actions Permalink

Please sign in to leave a comment.

Folllowing List for Post: Reporting: Created to completed duration
[this list is visible for admins and agents only]

Community

Welcome 🖖

Hi there! 🙂 Want to become a black belt Wrike Ninja? Here's how to earn a Wrike badge

Welcome 🖖 Have you checked out this week's Release Notes yet?

Hey! 👋 Curious about something? Visit How To to search and ask the Community for answers.

Welcome! 👋 Figured out a good tip or trick? Share it in Best Practices.

Want to connect your existing software to Wrike? Learn and ask how in the API section.