eazyBi show time logged during selected sprint

Question

I have an eazyBi report for time logged by epic.

my columns include the Epic Link.

my rows include: Measures -> Calculated members -> Hours spent with sub-tasks

my pages include: Project, Sprint, and Logged by (user)

the problem is that when I select a sprint I see all the time logged for all the issues in the sprint. for issues that span multiple sprints (unfortunately that happens sometimes) the report will tally all the logged time.

how can I limit the report to select only the log entries between the selected sprint's start and end dates?

Many thanks,

N

eazyBI Support · Answer

Hi @Nuria Llobera Vila,

It seems there was some formatting mistake in given formula; instead of '&gt' should be an equation symbol '>'.

In eazyBI Support answer Mar 24, 2017, the formula is fixed now.

Best,

Zane / support@eazyBI.com

Nuria Llobera Vila · Answer

Hi Daina,

I tried your code and I get the following error:

Formula is not valid: 
Syntax error at line 4, column 43, token '&gt'

Is the code above actual?

Best regards,

Nuria

eazyBI Support · Answer

The formula below takes into account hours spent in Sprint for incomplete issues as well:

NonZero(SUM(Filter(
  Descendants([Issue].CurrentMember, [Issue].[Issue]),
  ([Measures].[Transitions to],
   [Time].CurrentHierarchy.DefaultMember) > 0),
  SUM(
    Filter( 
    { [Time].CurrentHierarchy.Levels('Day').DateMember([Sprint].CurrentMember.get('Start date')):
      [Time].CurrentHierarchy.Levels('Day').DateMember([Sprint].CurrentMember.get('End date')) },
    [Measures].[Issues history] > 0) ,
     NonZero (([Measures].[Hours spent],
       [Issue].CurrentMember,
       [Sprint].DefaultMember))
  )
))

The formula could have performance issues.

Currently, we are working on changes in Sprint scope management to improve precision and performance.

Daina / support@eazybi.com