How to Calculate DDIFF between Status X and Complete in Analytics?

In Wrike Analytics, does anyone know how would I go about calculating the length of time from the date a task was changed to a particular status to the completed date for the completed tasks? Once our review tasks are actually started, the task goes from scheduled to a specific status. I want to calculate the DDIFF between when the task is changed to that status and when the task is marked as complete (there are statuses in between). This could also be calculated based on when it leaves a particular status.

I tried to use the DDIFF between the start and completion dates, but since we have users that actually start their projects months after the task start date (and don't update the dates) it is returning garbage data for us.

The Analytics information in the Wrike help center is bare-bones and only covers super basic items (like it lists its available functions, but not how to use them). Yes, I've had the deployment session with them as well, and honestly, I had already built more robust dashboards than anything they showed me during that training. I contacted support to be told that there is another add-on that we would need to purchase for them to tell me if it is possible to do what I want, and the formula to do so (something that would have probably taken less time than the email response I received to buy their additional training). I understand that they deserve payment for support, but they have literally zero training or documentation on how to do things in the system... they make you rely on paying them rather than being able to research it on your own. 

My request to the people at Wrike - 

Make training documentation for Wrike Analytics available to users who are already paying for the program. 

 

 

 

0
4 comentários
Spot On Innovative Approach Stellar Advice
Avatar
Hi Ashley Fischer, thank you for posting.
 
I see that you're in touch with our Support Team and that they've offered you a call session to go through your questions on Analytics. I've shared your feedback with our Help Center team. We also offer a Discover course on Introduction to Wrike Analyze, if you'd like to check it out. Please let me know if I can help you with anything else.

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

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

0
Ações de comentário Permalink
Spot On Innovative Approach Stellar Advice
Avatar

I figured out the formula - I exported my table with completion dates and the date that the task changed to status X and used excel to give me the day difference and average. I continued to work on the formula in analytics and I have created a formula that matches the average from excel:

(SUM([Task Status Change History Time Spent (minutes)]),[Task Status Change History Old Status],[Days in Task Completion Date])/60/24 / (DUPCOUNT([Task ID]),[Task Status Change History Old Status],[Days in Task Completion Date])

1
Ações de comentário Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi Ashley Fischer, thank you for coming back here and sharing the formula you've created 🙌🏼

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

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

0
Ações de comentário Permalink
Spot On Innovative Approach Stellar Advice
Avatar

Hi Cansu! Could you explain why are you passing 3 arguments in the first part of the formula? I'm looking at it and this is how I'm understanding it:

Factor 1:

SUM([Task Status Change History Time Spent (minutes)]) - This returns the time spent in the status

[Task Status Group] - No idea why is this used. How this returns a number? 

[Days in Task Completion Date] - Same as above

/60/24 - Converting to a number?

Factor 2:

Returns the number unique tasks

Is that correct? Thank you!!!

 

 

0
Ações de comentário Permalink

Folllowing List for Post: How to Calculate DDIFF between Status X and Complete in Analytics?
[this list is visible for admins and agents only]

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