Story Points closed by Initiative Sponsor over Time

Questions & Answers
1

New to eazyBI and I am trying to build a report that will be valuable to our team.

In our JIRA hierarchy, we have Initiatives that parent Epics that parent Stories. We have a custom field on the Initiative to indicate the Sponsor. I would like to graph (stacked bar chart) story points closed over time stacked by the sponsor on the parent initiative.

I have tried several approaches but haven’t found a way to do this yet. When I prompt the AI to build this for me, the closest I have been able to get is something like this:

image
image1203×837 64.8 KB

Ideally, it would be something like this:

Column 1 Column 2 Column 3 Column 4
Time All Sally Bob
Apr 24 200 100 140
May 24 350 200 100
Jun 24 400 150 20
2

Hi,

The recommended solution to this use case is to create a new Javascript-calculated dimension that inherits down the Sponsor field value from Initiative.

This documentation pages explains how to do that: Epic level custom field.

The update parameter for this custom field should be

update_from_issue_key = "jpoh_parent_3"

Kindly,
Janis, eazyBI support

1 Like
3

Thanks for your help with this!