Hi all,
I have a dataset that includes customer escalation tickets that have been or will be worked and resolved by agents. The data includes CREATE_DATE of the ticket and RESOLUTION_DATE. The tickets have a 5 business day SLA period from their CREATE_DATE to be resolved. What I am trying to calculate is how many days, if any, the tickets went past their 5 day SLA before resolution. Right now I picture the card as a stacked bar graph with the # of days past SLA grouped (i.e - under SLA group, 1-5 days past, 10-20 days past, etc.) and also organized by month.
I am not sure if I can do this days past SLA calculation in Beastmode using the Date Difference function, or if I will need to do this some other way? I have experience with simple Beastmode but not much more advanced than that. Apprecaite any input.