Get “Total Story Points” and “Remaining Story Points” in EazyBI

[Rahul Mittal]

Hi,

I am new to EazyBI and till now have just build graphs and table using the existing dimensions.

I have a requirement to prepare a tabular view which tell me “Total Story Points” and “Pending Story Points” for a Planned FixVersion.

My Project Hierarchy is:

JIRA Project 1 —> STORY1

JIRA Project 2 —> FEATURE1, FEATURE2, FEATURE3

And, STORY1 is linked as “has these children” to FEATURE1, FEATURE2, FEATURE3

The story points are allocated to FEATURE1, FEATURE2, FEATURE3

Now, “Total Story Points” and “Pending Story Points” are calculated basis on status of FEATURE1, FEATURE2, FEATURE3, i.e. if:

FEATURE1 - 2 Story Points
FEATURE2 - 5 Story Points & status=closed
FEATURE3 - 5 Story Points

So, “Total Story Points” = 12 & “Pending Story Points” = 7 && “Percentage completed”= 41%

Please guide me on how this can be achieved.

Regards,
Rahul