eazyBI - created Time Calculated Member to focus a Timeline chart on a specific time period

unknown

I simply want to create customer Calculated Member in the Time dimension to focus only on subset of dates.  I know I can filter on the Timeline x-axis via the "between" mechanism, but the issue is that my cumulative created issues don't start at zero.  I only want to have the cumulative created (and resolved) to start a zero, so I want to completely limit the date range.

So I can I limit the Tim dimension to say, 2016-12-09 to 2017-02-01 lets' say, or to today(now)?

 

eazyBI Support

Hi Brian,

 

In that case, you could define a new calculated member in "Time" dimension (weekly hierarchy) using this code example:

 

Case when
  DateBetween(
    [Time].CurrentHierarchyMember.StartDate,
    [Time].CurrentHierarchy.Level.DateMember(
        'Dec 9 2016').StartDate,
    Now()
  )
Then
  SUM (
    {[Time].CurrentHierarchy.Level.DateMember(
        'Dec 9 2016'):
     [Time].CurrentHierarchyMember },
    [Measures].[Issues created]
  )
End

That would calculate the cumulative issues created only for period from Dec 9 2016

 

cumulative for subset of dates.jpg

 

Please contact support@eazybi.com if you have further questions regarding this!

 

Kind regards,

Martins Vanags / support@eazybi.com

cumulative for subset of dates.jpg