Hello,
I need assistance with calculating the total time spent for each issue collectively (sum) in the statuses “On hold,” “Waiting on Vendor,” and “Waiting on customer.” Using the measure found on the page here, I managed to determine the number of days in a given status. However, the following issues have arisen:
- If an issue has multiple statuses, it only counts one (for example, it only includes “Waiting on Vendor” and ignores “Waiting on customer”).
- If an issue has been in one status multiple times (e.g., transitioned from “Waiting on customer” to another and then returned), it only includes the time in the last “Waiting on customer” status. I need the sum.
Thank you in advance.