I’m trying to create a report which will give me the number of subtasks of specific issue type per parent issue. In the screenshot below, I have the parent issue on the left-hand side. The first parent issue has 4 subtasks, of which 2 are of issue type Risk and 2 are of issue type Dependency. I would like to create measures which show how many subtasks of each subtask type there are per parent issue, i.e. 2 in Dependency Subtask column and 2 in Risk Subtask column.
I tried to use variations on code below, unfortunately I didn’t find anything that would work.
([Measures].[Sub-tasks created],
[Issue Type].[Dependency Subtask])
The calculated measure “Dependency Subtask” looks for issues with type Dependency Subtask and that also has some subtasks under it. As Dependency subtasks are sub-tasks themselves and can not have any other sub-tasks, the calculated measure returns no data.
To make this work, you might want to use the Sub-task hierarchy in the Issue dimension. And then you may use measure Issues create for the calculation to represent subtasks with a particular issue type. When using a hierarchy, measure values are automatically aggregated from lower hierarchy levels. In this case, the measure “Issues created” would show one for the issue itself plus count of sub-tasks under it.
Can I get the complete query and where I need to keep that query and Can I get any sample report on the same. also if you could help me with the Resources assigned