I want to measure the time that the case status of case [sn_customerservice_case] was "Open" and out

[Community Alums]

I want to measure the time that the case status of case [sn_customerservice_case] was "Open" and output a report.
I would also like to do this for cases that have already been closed.
The goal is to measure the time that Tier 1 was working on that case.

I would like to exclude from the above time the time when the task tied to the case was open.
Please let me know if there is a good way to do this.

[Uncle Rob]

Do you have a date field that tracks when the case was closed?

[Community Alums]

The case table has a field with a close date and time.