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

I want to count open issues assigned to a specific user in the past per month.

Example picture:
openissuespermonth

Is this possible with eaziby, to measure with user events in the past? If possible, how?

JQL filter is unfortunately not an option in my case.

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

Many thanks for your answer Janis! Suggestion number 2 is what I was looking for and it works very well. You can see the result and what I am trying to achieve in another topic I have created: Expand a specific row or column

The next question I have is how, instead of Assignee, I can calculate based on users from a group in a custom User Picker field. I have opened a separate ticket for this: Make calculations based on users from a group in a custom User Picker field