Number of stories under Initiative

Questions & Answers
,
1

Hi, I have a structure in Jira that is Agile Initiative → Epic → Story.

What MDX do i use in a calculated measure to return the number of stories within a specific Agile Initiative with status ‘Ready for Development’?

Thanks,
Mark

2

Hi @mctaggartm
Welcome to eazyBI Community!
If your hierarchy is implemented using Plans (formerly Advanced Roadmaps), you might consider using issue link field dimensions to filter stories by their parent initiative’s properties.
See here how you can import the Plans hierarchy - Plans custom fields

Once that is imported, you can update eazyBI settings (Advanced settings for custom fields) with the code as given in the example in this documentation (Initiative status) - Issue link field dimensions

After importing this dimension, you could then use it in your reports to filter stories based on their parent initiative’s status.

Let me know if this works for your specific setup, if you get stuck with any of the steps or if you have some follow up questions!

Best wishes,

Elita from support@eazybi.com

3

Hi Elita, thanks for the response. I want to return the number of stories that have the status ‘Ready for Development’ that are under a specific initiative. I am not worries about the initiative status. Is it possible to do this within a custom measure? Thanks

4

Hi @mctaggartm

Thanks for the follow-up!

In that case you may want to define a new calculated measure in the Measures dimension using the Tuple function (Tuple) that will count the stories created under your Initiative where the Story status is Ready for Development.

(
  [Measures].[Issues created],
  [Issue Type].[Story],
  [Status].[Ready for Development]
)

See example in the screenshot below how it may look.

image
image1790×1430 270 KB

Best wishes,

Elita from support@eazybi.com

5

Thanks for the reply. Is it possible to specify the initiative within the measure itself? I want to have projects/teams in rows whereas you have themes in rows (above).

6

Hello @mctaggartm

Thanks for the clarification!
In that case, add another line in the Tuple function where you refer to this specific Initiative. If you are using the Plans hierarchy and have imported the Parent link, the dimension should come up similarly as this (in my case Plans Theme):

(
  [Measures].[Issues created],
  [Issue Type].[Story],
  [Status].[Done],
  [Plans Theme].[ETQ-349]
)

image
image1674×822 61.9 KB

Best wishes,

Elita from support@eazybi.com

7

Thanks Elita this solution worked well

1 Like