Hi @Mollie,
First, You might want to count how many issues were resolved within the priority-base SLA in each period. Create a calculated measure (in Measures) to check on each resolved issue and compare issue resolution time to the SLA target for priority.
Sum(
--set of issues resolved in period
Filter(
--iterate through individual issues and check the resolution date
DescendantsSet([Issue].CurrentMember,[Issue].[Issue]),
DateInPeriod(
[Issue].CurrentMember.Get('Resolved at'),
[Time].CurrentHierarchyMember
)
),
--numeric expression to compare resolution time with target
CASE WHEN
--write the condition for each priority
([Measures].[Issue priority] = "1-Critical" AND
[Measures].[Total resolution days] < 0.125) --3h is 0.125 of the whole day
OR
([Measures].[Issue priority] = "2-High" AND
[Measures].[Total resolution days] < 3)
OR
([Measures].[Issue priority] = "3-Medium" AND
[Measures].[Total resolution days] < 5)
THEN 1
END
)
Now you can use this measure for further calculations. For example, using subtraction of the measure “Issues resolved” and the newly calculated measure to get how many issues were resolved outside of the set time box. Or divide the newly calculated measure by “Issue created” or"issue resolved" to get the percentage of success in a period.
More details on calcauted measures and how to perform arithmetical operations to get percentages are here: Calculated measures.
When calculations are created, use conditional cell formatting to highlight the good and bad results. See this community post for several use cases examples:
Best.
Zane / support@eazyBI.com