Hi All,
Can some one please help me with getting a count of SLA Breached issues based on their status?
I am aware that there’re Service Management Measures that gives the count for SLA Breached issues. But they are not status specific.
I am still new to eazyBI and have tried to create a calculated member using below formula but it gives the wrong count.
Aggregate(
filter(
[Measures].[X SLA - Breached] ,
NOT [Measures].[Issue status] = "Rejected"
)
)
With this formula I am trying to get a count of Issues that have breached the ‘X SLA’ but their Status != “Rejected”