Sprint Issues Committed (But not in Done Status) measure

Questions & Answers
1

Hi,

Hoping this is a simple one. How would I go about amending the following calculated measure “Sprint Issues Committed”:

( [Measures].[Transitions to],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
– An issue was in a sprint at a sprint start time
[Issue Sprint Status Change].[Future => Active]
)

to instead show me the same but only pull through items that were not in a Done status category at the same time as the point of commitment? I need this to rectify a number of issues being caused due to some bad inputs on Jira.

Thanks.

2

Hi @jseal123 ,

For such a requirement, I recommend defining a new calculated measure aggregating the two Transition Status dimension “Category” hierarchy members and evaluating them over the measure “Sprint issues committed”. The formula could look similar to the one below:

Aggregate(
  {[Transition Status.Category].[To Do],
  [Transition Status.Category].[In Progress]},
  [Measures].[Sprint issues committed]
)

Please look at the eazyBI documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com