Measure to count number of subtasks of specific issue type per parent issue

Hi there,

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])

Help will be much appreciated!

Hi @bar368,

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.

The calculation might look like this:

([Measures].[Issues created],
[Issue Type].[Dependency Subtask])

The report might look like in the picture below:

Best,
Zane / support@eazyBI.com

Hi Zane,

Thank you so much for your help, this works perfectly!

1 Like

Hi @zane.baranovska ,

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

Regards,
Maheshwar Reddy