Help with Beast mode to calculate time in tier
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…