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”:

[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:

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


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:
See folder 6 Links and Hierarchies and measure “Hours spent on Linked Bugs” used in those reports.

Ilze /