Report based on time stamps
Greetings!
I'm trying to create a report that shows the time stamps of when statuses change. Best case, I'd like to report on when a task status was changed to In Progress and when it was changed to Completed.
For example
Project has task A, B and C
Project has task A, B and C
When was task A changed to In Progress? When was task A changed to Complete? What was the delta?
It looks like the data exists in the task already. Now would just be great to report on it!
Thanks for any ideas on how I can accomplish this!
Thank you!
Hi Steven Vogt, thanks a lot for reaching out!
The closest thing available is Workflow Reports that allow you to view the average amount of time tasks spend in a particular status; see what percentage of tasks change from one status to another, and view the average number of changes from one status to another which occur on a weekly basis.
I can move your post to our Product Feedback forum and pass your suggestion to our Product team, 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
I use the Timelog view to get an idea of how much time a project has taken and when people where working on it. It is dependent on people tracking their time for their tasks, but it shows the date they worked on the task and how much time they spent on it. You can also pop the task out into a modal window to see more details.
The first thing you have to do when you open Timelog view is to change the "Filters" in the upper left. It always defaults to "this week".
It groups the tasks by folder and gives a grand total at the far bottom if the screen, labeled "sum". If a task is in two different folders, then it will show up twice, but the grand total at the bottom will still be correct.
You may also be able to use a Time Spent report to automate this: https://help.wrike.com/hc/en-us/articles/1500005122861-Creating-a-Time-Spent-Report
Thanks! Will give those a shot! Is there any way to get this data with the API? It could even work to just say:
Task A in Project A was started at 10:00 AM on 1/1/2022.
Task A in Project A was completed at 10:10 AM on 1/1/2022.
I have to imagine those time stamps exist somewhere?
Thanks!
Hi Steven Vogt, I believe our API document here can help you to build the integrations. Please let me know if you have any questions 🙋🏻♀️
Cansu Community Team at Wrike Wrike Product Manager Become a Wrike expert with Wrike Discover
Cansu Wrike Team member Become a Wrike expert with Wrike Discover