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.