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, as for the second step, I needed the sum of all “Cloned Hours Spent” by Roadmap (defined as a row and page), with the data above it would be something like this:
Thanks!