Filter Issues using Calculated Member or Measure for Timeline

Questions & Answers
1

Hello,

I’m trying to create a burndown chart for issues that meet either have a parent with “Release Note?” as Yes or a grandparent with “Release Note?” as yes. I’ve tried multiple ways so far.

  1. I tried adding the field link to the advanced settings, but it won’t let me add from multiple hierarchies

[jira.customfield_12548_e]
name = “Epic Release Note?”
data_type = “string”
dimension = true
update_from_issue_key = “epic_key”
javascript_code = ‘’’
if(issue.fields.customfield_12548 ) {
issue.fields.customfield_12548_e = issue.fields.customfield_12548;
}
‘’’

[jira.customfield_12548_e]
name = “Master Feature Release Note?”
data_type = “string”
dimension = true
update_from_issue_key = “jpoh_parent_3”
javascript_code = ‘’’
if(issue.fields.customfield_12548 ) {
issue.fields.customfield_12548_e = issue.fields.customfield_12548;
}
‘’’

  1. I tried creating a calculated measure, but it doesn’t work when I make a graph in the time dimension

Sum(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
([Issue].CurrentMember.Parent.Get(‘Release Note?’) = “Yes” OR
[Issue].CurrentMember.Parent.Parent.Get(‘Release Note?’) = “Yes”)
AND
DateInPeriod(
[Measures].[Issue created date],
[Time].CurrentHierarchyMember
)
),
[Measures].[Story points created]
)

  1. I tried making a calculated member, but this isn’t working either.

Aggregate(
Filter(
– iterate through set of issues
Descendants([Issue].CurrentMember,[Issue].[Issue]),
– apply filter criteria to each issue
[Issue].CurrentMember.Parent.Get(‘Release Note?’) = “Yes” OR
[Issue].CurrentMember.Parent.Parent.Get(‘Release Note?’) = “Yes”
)
)

I just want this burndown filtered. Please help!

image
image1618×365 17.6 KB

2

Hi @chelsie

Thanks for the details!

A couple of things here:

  1. I see that both of these custom fields have the same internal name:
[jira.customfield_12548_e]

Please use a different internal name for each of these. Note that you’ll have to change the value in the formula as well:

[jira.customfield_12548secondfield]
name = "Master Feature Release Note?"
data_type = "string"
dimension = true
update_from_issue_key = "jpoh_parent_3"
javascript_code = '''
if(issue.fields.customfield_12548 ) {
  issue.fields.customfield_12548secondfield = issue.fields.customfield_12548;
}
'''

  1. Could you please expand on what exactly you would like to show in the report? For now, the formula seems to check the Release note and then check if the issue was created in that Time period, if yes, then count SPs created. But this will not show any cumulative SPs or a burndown chart. Any additional details- on what exactly you would like to show would be helpful!

  2. The Aggregate function is usually used for Aggregating members in other dimensions. Again- any additional details on what you would like to achieve with this report would help me help you :slight_smile:

​Best regards,
​Nauris

3

Thanks for the response @nauris.malitis . My ultimate goal is to filter the burndown chart with just issues that have a parent with Release Note = Y or grandparent with release note = Y.

4

Hi @chelsie

Got it!

However, what, in this case, do you mean by burndown chart? What is the number of open issues across some specific time period? Any other measures? What should be the time period for this chart?

Thanks!