Hi,
I’m trying to create a report where I need to see all tickets that were historically or are in “In Progress” status and a list of their Assign in this status.
Currently, I only receive a historical list Assignees of tickets that are currently in “In Progress” status. But I also need to see the tickets that were historically in this status and their Assignee.
How do I extend MDX with historical issues (only tickets currently in “In Progress” status are displayed)?
I have this Calculated Measure:
Generate(
--go through all Assignee users
Filter(
[Assignee].[User].Members,
--check wheather user was assigned to issue at some point
([Measures].[Transitions to assignee],
[Time].CurrentHierarchy.DefaultMember) > 0 ),
--get assignee names separated by comma
[Assignee].CurrentMember.Name,
","
)
Thank you for your help
Pavel