Total time spent sum on linked issues by roadmap

Questions & Answers
#1

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:

image
image1320×158 14 KB

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:
2020-12-21_19-04

Thanks!

#2

Hi @Miguel_Silva,

You may want check out a sample report in one of our demo accounts where linked issue information is used in the report (dimension Bugs contain linked bugs) and there are several useful measures used in the report to count linked bugs, hours spent on linked issues etc. and which you may modify and use in your case: Issues - eazyBI Demo Training - eazyBI
One of the examples could be Hours spent on Linked Bugs (in your case change the dimensions to yours):

Case 
When
  [Issue].CurrentMember.Level.Name = "Issue"
  AND
  [Bugs].Currentmember is [Bugs].Defaultmember
Then
  -- retrieve Bugs information from Issue property Bugs
  Case when
    not isEmpty([Issue].CurrentHierarchyMember.Get('Bugs'))
  then
    NonZero(SUM(
    [Issue].[Issue].GetMembersByKeys(
      [Issue].CurrentHierarchyMember.get('Bugs')),
      DefaultContext((
        [Measures].[Hours spent],
        [Issue].CurrentMember,
        [Time].CurrentHierarchyMember,
        [Logged by].CurrentMember))
    ))
  end
Else
 -- total calculation for any issue, data on Bugs level
  NonZero(SUM(
    Filter(
      Descendants([Bugs].Currentmember, [Bugs].[Bugs]),
      -- filter out Bugs with reference to Issue
      ([Measures].[Issues created],
      [Logged by].Defaultmember, 
      [Time].CurrentHierarchy.Defaultmember) > 0),
    -- search for Bug in Issue dimension, use in a tuple with measure, logged by and time, ignore anything else with DefaultContext    
    DefaultContext((
      [Measures].[Hours spent],
      [Issue].[Issue].GetMemberByKey([Bugs].Currentmember.Key),
      [Logged by].CurrentMember, -- allow selection by Logged by
      [Time].CurrentHierarchyMember, -- allow selection by Time
      [Bugs].DefaultMember
    ))
 ))
End

But if this doesn’t suit your use case, can you send report definition as well as advanced settings on how you create linked dimension to support@eazyBI.com?

best,
Gerda // eazyBI support team