Average number of issues closed per assignee

Looking to create a measure that will calculate average number of issues closed divided by the number of assignees (for that day) for each agent.

  • I understand I need to create a formula that will look something like this: (issues closed)/(number of assignees). What I’m struggling with is pulling the number of assignees as a dynamic number - for example, on Tuesday only 34 assignees are assigned issues but on Wednesday 36 assignees are assigned issues. Is there a way to capture this possible change?

Thanks!

Hi @Coulby_Riehl,

Here is the formula (we discussed it in the mail, but also for the community) - this will count how many users were assigned to issues by the end of each day:

NonZero(Count(
  Filter(
    Descendants([Assignee].CurrentMember, [Assignee].[User]),
    [Measures].[Issues history] > 0
  )
))

Lauma / support@eazybi.com