Reaching out to the community in hopes that someone has dealt with the use case I'm struggling with.
Our support organization operates in a tiered model (Tier 1, Tier 2, and Tier 3). I'm in need of assistance writing a beast mode to calculate the amount of time a ticket sat in each of the tiers.
Using the above table, I understand the calculation to be as outlined below. However, writing it in beast mode is not as easy, at least I'm not finding it to be.
Time in Tier 1
- 2022-03-01T07:37:11 (TICKET_HISTORY_UPDATED_AT) - 2022-03-01T06:54:29 (CREATED_AT)
- TICKET_HISTORY_UPDATED_AT aligned to Tier 2 as this is when the ticket was assigned to group
- Total time in Tier 1 would be 43 minutes
Time in Tier 2
- 2022-03-08T10:22:34 (TICKET_HISTORY_UPDATED_AT) - 2022-03-01T07:37:11 (TICKET_HISTORY_UPDATED_AT)
- TICKET_HISTORY_UPDATED_AT aligned to Tier 2 as this is when the ticket was assigned to group
- TICKET_HISTORY_UPDATED_AT aligned to Tier 3 as this is when the ticket was assigned to group
- Total time in Tier 2 would be 165 minutes