Column in Pivot table to display how long a task was in a particular status
Hello!
I am creating a pivot table on my analyze board. I want the pivot table to display the task name, assignee, Days it took to complete task, and how long (or if) a status was in the status 'On Hold'.
I am having trouble getting the 'Amount of time in On Hold Status' to display correctly. I simply need it to show the amount of time that task was in the status 'on hold'. I have this formula: (([Total Task Status Change History Time Spent (minutes)]))/60/24. But I can't get it to filter to 'On Hold' without filtering the entire board. If a task was never in the status 'On Hold' it should display a 0. Please Help!
I hope I explained that well enough.
Thank you!
Hi Crystal Fugate! Thanks a lot for sharing your case in the Community 🙌 I've asked our Wrike Analyze experts from the Support team to reach out to you to help with your question. They will reach out to you shortly. Please feel free to then share your findings here in the thread 🙂
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