How to list most recent assignee(s) for a component?

Hello!
I am wondering if it is possible to print within a table the last few ‘Test Owners’ (custom field made into a dimension) for a series of components? Goal: Identify the current ‘go to’ Test Owner personnel across a subset of components.

Any help would be greatly appreciated!

Hi @Chelsea.Hess ,

Your requirement is possible. Although there is still the question of how you determine the last few “Test Owners”? One way is analyzing the field change history. That is possible for single-value fields. Please see the eazyBI documentation page on how to enable that - Import issue change history.

Suppose the “Test Owners” field is a single-value field; you have enabled the change history and imported it. In that case, define a new calculated measure that iterates through all Test Owner dimension members and retrieves the last two by the change date. See the formula and a picture of the report below with the T-shirt size dimension instead.

Generate(
  Tail(
    Order(
      Filter(
        [T-shirt size].[T-shirt size].Members,
        ([Measures].[Transition to last timestamp],
        [Transition Field].[T-shirt size],
        [T-shirt size].CurrentMember) > 0
      ),
      [Measures].[Transition to last timestamp],
      ASC
    ),
    2 -- <-change the number of members to retrieve
  ),
  [T-shirt size].CurrentMember.GetString('KEY'),", "
)

Replace the T-shirt size dimension and level names in the formula to fit your use case. Please look at our documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com