Calculated Measure

Questions & Answers
1

Help with calculating Average Sub-tasks hour?

2

You can consider calculating the average hours spent by dividing Hours spent with measure counting Issues with hours spent. Use this measure in a tuple with issue type sub-task to apply the formula for sub-tasks only.

CASE WHEN
([Measures].[Hours spent],
[Issue Type].[Sub-task])
> 0
THEN
([Measures].[Hours spent],
[Issue Type].[Sub-task])
/
([Measures].[Issues with hours spent],
[Issue Type].[Sub-task])
END

I added additional validation to check if there is logged time on sub-task issues to avoid any errors.

Daina / support@eazybi.com

1 Like