Sum of time spent on linked issues by roadmap

Hi everybody!

I’ve defined a new dimension for cloned issues that is working pretty well.

With it, I can retrieve the time spent on one clones as seen here:

To do that I’ve defined a new calculated metrics “Clone Hours Spent”:

DefaultContext((
[Issue].[Issue].GetMemberByKey([Cloned from].CurrentMember.key),
[Measures].[Hours spent]
))

Now, what I is to have the sum of all “Cloned Hours Spent” by Roadmap, with the data above it would be something like this:
2020-12-21_19-04

Also, the “Roadmap” dimention is a page, as well as the “Time” dimention (to select a month).

Thanks!

Does anybody have any idea of how to do this?

pretty little bump for 2021!

Hi Miguel,

The bump was needed indeed, sorry!

For linked issues calculations, there is a great source with examples, a public eazyBI account: https://eazybi.com/accounts/22010/cubes
See folder 6 Links and Hierarchies and measure “Hours spent on Linked Bugs” used in those reports.

Best,
Ilze / support@eazybi.com