How can I create a report that shows, whom the ticket was pending to (either assigned, reporter or approver etc.) when it breached (Either To Do, InProgress or Done).
Hi @CyberTechGroup ,
To be able to show the Assignee who breached the SLA, eazyBI needs to have access to the exact date and time when SLA was breached. Unfortunately, such information is not available from the Jira. We have an improvement ticket opened, and I have added your vote. If and when such a feature is implemented, we will notify you.
If it helps:
For completed SLA cycles, you can generate a list of Assignees who were assigned to the issue at that moment, for each SLA would be a separate measure.
See a formula example for Assignees when the SLA cycle was completed and it was breached:
Generate(
Filter([Assignee].[User].Members,
([Measures].[Time to resolution Completed cycles],
[Time to resolution Breached].[Breached])>0
),[Assignee].CurrentHierarchyMember.Name,"; ")
A similar approach can be used for not breached issues.
Generate(
Filter([Assignee].[User].Members,
([Measures].[Time to resolution Completed cycles],
[Time to resolution Breached].[Not breached])>0
),[Assignee].CurrentHierarchyMember.Name,"; ")
best,
Gerda // support@eazybi.com