We are looking to created a report to show “all hours spent on all children of an Epic with X Label on the sub-tasks.”
Similar to the solution provided below, but we are looking to create a “Subtask Label.”
I tried adding the below snippet to Advanced Settings, but not sure if “subtask_id” is correct as Subtask Label does not show up in the Linked issue dimensions.
[[jira.issue_link_field_dimensions]]
name = “Subtask Label”
source_dimension = “Label”
issue_id_column = “subtask_id”
group = “Linked issue dimensions”
Issue link field dimensions were designed to pass down the values from any higher level issues to children issues. For example, if you have a Label in Epic, pass it down to issues in epic.
Any default dimension, including Label, will pull in issues and values in those issues with a particular label.
(
[Measures].[Hours spent],
-- address label to check on sub-tasks here
[Label].[subtask label],
-- check label in issues with this subtask name:
[Issue Type].[Sub-task]
)
For more advanced case, you would like to use issue level calculations to pull in values from issues in epic if there is a sub-tasks with a particular label.
For example, if you would like to pull Hours spent from any issue in the Epic (Epic included) if at least one sub-task has a particular Label, you can use a formula similar like this:
Sum(
Filter(
Descendants([Issue.Epic].CurrentMember,[Issue.Epic].[Epic]),
([Measures].[Issues created],
-- address label to check on sub-tasks here
[Label].[subtask label],
-- check label in issues with this subtask name:
[Issue Type].[Sub-task]) > 0
),
[Measures].[Hours spent]
)
Hi, and if I just need to see the sum of hours spent for 3 specific Epics, will it be like this:
(
[Measures].[Hours spent],
[Epic].[Epic X name],
[Epic].[Epic Y name],
[Epic].[Epic Y name],
)
If you have several members (Epics in this case) you would like to use a function Sum over a set of those members.
You can access Epics with Issue.Epic hierarchy by listing Epic by epic issue key. Epic hierarchy uses keys instead of names to address particular issues.