Week over Week % Change for SLA Targets %
Hi,
I am trying to create a brief summary report, which contains % change for different time ranges (week over week, month over month, etc.).
I have trouble getting this to work for my custom standard calculated metric: SLA Targets % (WoW)
(COUNT(SLA % Last Week) - COUNT(SLA % Previous Week)) / COUNT(SLA % Previous Week)
Custom metrics used:
Date range calculated metric SLA % Last Week = Original metric % Achieved SLA targets Defined on SLA Update Date range Last Week
Date range calculated metric SLA % Previous Week = Original metric % Achieved SLA targets Defined on SLA Update Date range Previous Week
The date range calculated metrics SLA % Last Week and SLA % Previous Week work fine for themselves, but when using them both in the calculation (COUNT(SLA % Last Week) - COUNT(SLA % Previous Week)) / COUNT(SLA % Previous Week) it does not return any result.
Reference:
As a reference, (COUNT(Tickets Created Last Week) - COUNT(Tickets Created Previous Week)) / COUNT(Tickets Created Previous Week) is working fine without issues.
Looking forward to getting input here.
Best,
Marcel
-
Hi Marcel,
Thanks for reaching out! Due to the complexity of your report, I'd like to take this into a ticket for further investigation.
Look out for an email from me!
-
Marcel and I were able to figure out how to get this query to work, so I've put together an article for everyone else to get on board!
Check out our recipe here: Explore Recipe: Week over week SLA percentage change
Thanks again for being such an active member of our community Marcel!
-
Thanks again for your help, @Jessica! :)
-
Hi @Jessica! Thank you for the article!
I was wondering how do you apply this solution in order to see the percentage change for all the previous weeks (beyond last week and the week before)?
Please sign in to leave a comment.
4 Comments