How to calculate an SLA using a custom Issue Link Hierarchy?

Questions & Answers
1

Hi Everyone,

I have the following links hierarchy:
Evolutive (issueType) → Story (issueType) → Bug(issueType)

The goal is to calculate:
Number of bugs in all evolutives resolved in a month vs time spent in all evolutives.

Formula:
EQ1 = Sum(Bugs related to Evolutives resolved in a month) / Sum(Time spent of Evolutives resolved in a month) * 100
The SLA is breached if EQ1 < 97%

Example:

image
image811×563 33 KB

I tried to configure this link hierarchy but I am a little stuck in how to implement the formula.

image
image1355×658 54.9 KB

Advanced settings

 Stories linked to Evolutives
[jira.customfield_evolutives_stories]
name = "Stories linked to Evolutives"
outward_link = "relates to"
inward_link = "relates to"
issue_type = "Story"
# multiple_values = true
dimension = true

# Bugs linked to Stories
[jira.customfield_stories_bugs]
name = "Bugs linked to Stories"
outward_link = "relates to"
inward_link = "relates to"
issue_type = "Bug"
# multiple_values = true
dimension = true

# Evolutive hierarchy
[jira.customfield_evolutive]
name = "Evolutive"
outward_link = "relates to"
inward_link = "relates to"
issue_type = "Evolutive"
update_from_issue_key = "customfield_evolutives_stories"

[jira.customfield_story]
name = "Story"
outward_link = "relates to"
inward_link = "relates to"
issue_type = "Story"
update_from_issue_key = "customfield_stories_bugs"

How should I continue to achieve calculate the formula and display the result as table, text or gauge chart?

2

Try using the following hierarchy definition in advanced settings to define an additional custom hierarchy for “Issue” dimension.Additional Issue hierarchies

When settings are updated, go to the import options page and select to import “E Evolutiove” and “E story” fields as properties:

That should create a new hierarchy in “Issue” dimension that you can select and use in your report. It should automatically aggregate results

[jira.customfield_evolutivee]
name = "E Evolutive"
inward_link = "relates to"
issue_type = "Evolutive"
dimension = true
update_from_issue_key = "customfield_storye"

[jira.customfield_storye]
name = "E Story"
inward_link = "relates to"
issue_type = "Story"
update_from_issue_key = "parent_issue_key"
dimension = true

[[jira.issue_hierarchies]]
name = "Evolutives by Bugs"
all_member_name = "All Issues by Evolutive"
levels = [
{name="Feature",key_column="customfield_evolutivee",issue_type="Evolutive"},
{name="Story",key_column="customfield_storye",issue_type="Story"},
{name="Bug",key_column="subtask_parent_key"},
{name="Sub-task",key_column="subtask_key"}
]

Martins / eazyBI