Number of users assigned to an issue over its lifecycle?

Questions & Answers
1

Hi,

We have a request to report on the ‘resources involved in completing a task’, which translates to the number of assignees per issue from date created to date closed (the issue will often pass from one user to another depending on the status).

Broadly, I need the average number of assignees for each issue closed in the past month (for example).

I can’t see a measure in EazyBI that would achieve this?

Any pointers/tips?

Thanks so much :slight_smile:

2

Hi @Doug

There is no predefined measure for average number of assignee over its lifecycle,
But you can try creating a new calculated measure for this purpose:

CASE WHEN
[Measures].[Issues resolved]>0 -- not to calculate for empty rows
THEN
Avg(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    DateInPeriod( --filter by property for selected period
      [Measures].[Issue resolution date],
      [Time].CurrentHierarchyMember
    )
    AND
    [Measures].[Issues resolved]>0 --numerical measure for the report context
  ), --filter conditons finishes here
  --value for average function starts here
    Count(
      Filter(
        Descendants([Assignee].CurrentHierarchyMember,[Assignee].[User]),
        (
          [Measures].[Transitions to assignee],
          [Time].CurrentHierarchy.DefaultMember
        )>0
      )
    )
)
END

Next, you could create a calculated member in the “Time” dimension to return the previous month dynamically. Try this code:

Aggregate({
  [Time].[month].CurrentDateMember.PrevMember
})

It might be slow for a large report (depending on what you use in rows and columns) but it should do the trick.
See attached image below.

Martins / eazyBI support team

report%20example
report example.png2266×980 182 KB

3

Thanks so much @martins.vanags , that works perfectly!