History - Assignee in history status

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

Hi @pavel.junek ,

Please have a look at the eazyBI community post discussing a pretty similar question - How to list all assignees of an issue in particular status.

The suggested formulas focus on the changes during the status. If you want to include the assignee in the case it stayed unchanged during the particular status, you can add another condition inside the Filter() function:

    ...
    OR
    ([Measures].[Issues history],
    [Transition Status].[In Progress])>=0
    ...

The report then could look similar to the one below:

Best,
Roberts // support@eazybi.com

1 Like

It work’s fine!
Thank you Robert :slight_smile:
Pavel

1 Like