Spent hours for specific Issue Type

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.

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

Sorry for interrupting

2 Likes

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: https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members/calculated-measures

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

Best,
Zane / support@eazyBI.com

1 Like