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.