How to calculate the original committed feature and removed feature from PI

Question

Hi Team,

Have a specific ask to calculated how many features were originally committed for a PI (We have a custom field created to denote the PI) and how many delivered and how many removed from the PI.
Note: we dont have change of value for that field available and we are not having any plugins at this moment.
Is there any JIRA JQL we can look at it or in eazyBi if that is possible and we dont even have the Jira Align and can't go to it as of yet.

Oskars Laganovskis · Answer

Hi @Yatiraj Sharma ,

You could access the PI value at a historical point in time using the following expression.

CASE WHEN
--check if relevant for the rest of the report context
 ([Measures].[Issues history],
--resetting the PI dimension 
  [BRP/PI].CurrentHierarchy.DefaultMember)>0
THEN
 Generate(
--find the relevant PI
  Filter(
--set of PIs from the selection
   DescendantsSet(
--from currently applicable member/selection
    [BRP/PI].CurrentMember,
--take the level of individual entries
    [BRP/PI].[BRP/PI]),
--the issue was releated to the PI at the end of applicable time period 
   [Measures].[Issues history]>0),
--string part to display
 [BRP/PI].CurrentMember.Name,
--split by comma, if multiple relevant entries
  ",")
END

This might work but could get slower on larger datasets.

There might be a faster alternative option, depending on your full reporting requirements.

Alexey Pavlenko _App Developer_ · Answer

@Yatiraj Sharma

From my perspective, my filters above still cover your case. You can list all the sprints in JQLs that a PI consists of.

Another solution could be to create another custom field to track the history, such as a 'History PI' field. You can maintain it manually or automatically.

Best regards,
Alexey

Yatiraj Sharma · Answer

Hi @Oskars Laganovskis ,

Greetings !

Thanks a lot for the help, have imported the history of the custom field, However, need some help on how do we access to original value compared to current value?
Like current I can see is like this

[Issue].CurrentHierarchyMember.get('BRP/PI')

So for old value what is the custome calculated measure I have to use ??