Count the change of NEW assignee within an issue?

Questions & Answers
,
1

Hi Team,

Trying to workout how to get this new calculated member field for:

  1. count the number of change of Assignee from 1st assignment to Closure within an issue
  2. show how many times any issue is reassigned to NEW user, is it possible to take into account ONLY to new user BUT not reassignment to user that was assigned before?

Regards,
DS

2

Hi @daso,

Every time the issue changes the assignee, the Jira registers transition from the previous assignee to a new one.
Therefore, you might find the number of changes by looking up the number of transitions from the assignee in a predefined measure “Transitions from assignee”.

However, to count the number of assignees that have been assigned to the issue, you need to go through the Assignee dimension and filter the relevant ones.
The expression might be as follows.

Count(
  Filter(
--set of assignees
    DescendantsSet([Assignee].CurrentHierarchyMember,
                   [Assignee].[User]),
--condition for filter
  [Measures].[Transitions from assignee]>0
  )
)

Regards,
Oskars / support@eazyBI.com

3

Thanks @oskars.laganovskis I am getting a timeout for that query you have posted, I am looking to complete exactly what daso mentioned in point 1.

image
image751×311 3.62 KB

4

I also tried something along these lines,

IIf(((Aggregate({[Transition Status].[Done],
[Transition Status].[Cancelled]},
([Measures].[Transitions to status issues count],[Project].[AOS Program])))>0),(Aggregate([Measures].[Transitions from], [Transition Field].[Assignee]))>0,“false”)

But wasn’t able to get the second IIf MDX satisfied.

5

Hi @krish,

Welcome to the eazyBI community!

The transitions-related measures are from the “heavy end” of calculations. Therefore, they are best performed on a limited set of issues if you have a Jira instance with many issues and multiple transitions within each issue.

If you only have one member of each dimension, you do not need the Aggregate function, and if there is only one condition, you do not need to put it in brackets.
You might as well use a zero instead of “false”.
Your expression might then look as follows.

IIf(Aggregate({[Transition Status].[Done],
               [Transition Status].[Cancelled]},
    ([Measures].[Transitions to status issues count],
     [Project].[AOS Program])
    )>0,
    ([Measures].[Transitions from],
     [Transition Field].[Assignee])>0,
    0)

However, if you need further assistance, please get in touch with eazyBI support directly over e-mail since the behavior of that expression depends on the report context.

Regards,
Oskars / support@eazyBI.com