Spent hours for specific Issue Type

[Anton_Kruglikov]

Hello,

I have table with ‘Sprint’ rows and some Measures.
I want to add an additional measure, which calculates the sum of Spent Hours on specific Issue Type in the sprint.

Could you please help me with the formula?

Thanks in advance.

[Anton_Kruglikov]

Managed to do it via
Sum(
{
[Issue Type].[Framework]
},
[Measures].[Hours spent with sub-tasks]
)

Sorry for interrupting

[zane.baranovska]

Hi @Anton_Kruglikov,

You might want to use a tuple of an issue type and measure “Hours spent with sub-tasks” to get logged time on issues and its sub-tasks:

([Measures].[Hours spent with sub-tasks],
[Issue Type].[Framework])

There are more details on when to use and how to build tuples: Calculated measures

Another option is to set dimension “Issue Type” as on pages and filter issues by issue type of interest.
See related conversation:

List issues by Issue Type, and sub-tasks of that Issue Type

Hi @SDI, In eazyBI are available two measures, “Hours spent” represents logged hours on an issue itself and “Hours spent with sub-tasks” represents logged hours on an issue and its sub-tasks. There are more details on each predefined measure: https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/jira-core-measures-and-dimensions. For your report, you might want to use measure “Hours spent with sub-tasks” and filter data by Issue Type of parent issue, in your case Project. Then mea…

Best,
Zane / support@eazyBI.com