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)?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.