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”