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!

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

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

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

Folllowing List for Post: Column in Pivot table to display how long a task was in a particular status
[this list is visible for admins and agents only]

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