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
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!
2
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
9 comments

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

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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 

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

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!

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos
Avatar
Cansu

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 🙋🏻‍♀️

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

we are looking to do this without running a query on a separate software. please advise how we can go about this

1
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

we believe it should be easily done within the internal reports in wrike using the wrike timestamp

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Shira Parnes, welcome to the Community 👋

It's not possible with current Wrike reports, but there are workflow reports that you can try! Can this be helpful? 

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

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hi Lisa, team - can we additionally filter the Workflow Report to a specific project? Currently, while it can be filtered by dates, it appears to be pulling the data from all projects.

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Hey Bo Samreth, no, there are no additional filters available, the report is based on a certain workflow that may be used in various projects. 

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

0
👍 Spot On 💡 Innovative Approach 💪 Stellar Advice ✅ Solved 🪄 Remove Kudos

Folllowing List for Post: Report based on time stamps
[this list is visible for admins and agents only]

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