Count open issues assigned to a specific user in the past per month

Questions & Answers
3

Hi,

The solution for such a report in eazyBI would require a redesign of the standard Open issues measure. It is possible to reuse parts from that code, but there can be several ways to go depending on the exact details of your use case:

  1. Show the open issues for the users if the user was assigned at the end of the month:

    NonZero(Count(
    Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    IIF(
    DateBeforePeriodEnd(
    [Issue].CurrentMember.get(‘Created at’),
    [Time].CurrentHierarchyMember) AND
    NOT DateBeforePeriodEnd(
    [Issue].CurrentMember.get(‘Resolved at’),
    [Time].CurrentHierarchyMember),
    ([Time].CurrentHierarchy.DefaultMember,
    [Measures].[Issues created]),
    0)>0
    AND
    ([Measures].[Issues history],
    [Assignee].[Adam Mint])>0
    )
    ))

  2. Show open issues if the user has been assignee of the issue during the selected month:

    NonZero(Count(
    Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    IIF(
    DateBeforePeriodEnd(
    [Issue].CurrentMember.get(‘Created at’),
    [Time].CurrentHierarchyMember) AND
    NOT DateBeforePeriodEnd(
    [Issue].CurrentMember.get(‘Resolved at’),
    [Time].CurrentHierarchyMember),
    ([Time].CurrentHierarchy.DefaultMember,
    [Measures].[Issues created]),
    0)>0
    AND
    (([Measures].[Issues history],
    [Assignee].[Adam Mint])>0 OR
    ([Measures].[Transitions from assignee],
    [Assignee].[Adam Mint])>0
    )
    )
    ))

  3. Show open issues if the user has ever been assignee before the selected period:

    NonZero(Count(
    Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    IIF(
    DateBeforePeriodEnd(
    [Issue].CurrentMember.get(‘Created at’),
    [Time].CurrentHierarchyMember) AND
    NOT DateBeforePeriodEnd(
    [Issue].CurrentMember.get(‘Resolved at’),
    [Time].CurrentHierarchyMember),
    ([Time].CurrentHierarchy.DefaultMember,
    [Measures].[Issues created]),
    0)>0
    AND
    DateBeforePeriodEnd(
    TimestampToDate(
    ([Measures].[transition to first timestamp],
    [Time].CurrentHierarchy.DefaultMember,
    [Transition field].[Assignee],
    [Assignee].[Adam Mint]
    )
    ),
    [Time].CurrentHierarchyMember)
    )
    ))

You may notice that I used a specific name of the user in my formulas “Adam Mint”. You need to adjust it accordingly. Note also, that those calculations have a risk of the performance problems with a significant amount of issues in the account.

Kindly,
Janis, eazyBI support