Point in Time capture of Measures per Fix Version

Questions & Answers
, ,
9

Hi @MarkH401 ,

The our of memory error means that the calculation does not have enough resources to check the history of each individual issues that is imported in this specific account.

You may try another approach by multiplying count of issues that moved between specific statuses with their assigned Story Point value.

  1. Import “Story Points” field as dimension.
    In eazyBI import options, edit the Story Points field and mark it as Dimension, more details here: Custom field import options . then import it as dimension so yuo can use it for your report and calculations.

  2. In the report, now you can construct calculated measure from different perspective, without iterating though individual issues. The calculation will iterate possible Story Point values and multiply each value with the issue count that transitioned trough selected (specified Transitions).

Sum(
  --iterate though possible SP values except no value
  Filter(
    [Story Points].[Story Points].Members,
    [Story Points].CurrentMember.Name <> "(none)"
    AND [Measures].[Transitions to status issues count] > 0
  ),
  --for each SP value multiply it worth with issues that transitioned specific statuses
  [Measures].[Transitions to status issues count]
  *
  Val([Story Points].CurrentMember.Name)
)

You can use this measure in the report as it is, similarly to “Transitions to status issue count”, and filter report data by specific transitions or transition statuses.

  1. In the “Transition” dimension, define a new calculated member to group all transitions of interest ( Calculated members in other dimensions ).
Aggregate({
  [Transition].[In Test => In PO Acceptance],
  [Transition].[In Test => Ready for PO Acceptance],
  [Transition].[In Test => In BAT],
  [Transition].[In Test => Ready for BAT],
  [Transition].[In Test => Ready for Release]
})
  1. If this is more applicable option for the report layout, you can create another calculated measure (in Measures) to combine calculated measure for story points and calculated member of transitions:
([Transition].[Calculated member aggregating transitions of interest],
[Measures].[Transitions to status Story Points])

Best,

Zane / support@eazyBI.com