Time spent by components

[Stas]

Hi!
I have strange logical issue
I need to create hours spent report with “logged by” and “component” measures
like this

But when jira issue has 2 or more components - i need to devide hours spent by components
Otherwise my report would not be true (if i log 20 hours on issue with component A and B, in report it will look like i logged 40 hours total)

Cheers!

[Stas]

Created calculated field named “Components count” and used formula

CASE WHEN
[Measures].[Issue Components count] > 1
THEN
[Measures].[Hours spent] / [Measures].[Issue Components count]
ELSE
[Measures].[Hours spent]
END

seems works