EazyBI Filter Calculated Member

[atlassian-consulting@e-core.com]

Hi guys,

I have this calculated member:

Cache(
  NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
    [Measures].[Story Points resolved]
  ))
  + [Measures].[Story Points resolved]
)

But I need him to return only data from before today.

Exemple, this is what he returns now:

 image2016-8-31 14:25:25.png

But I need him to return data only from days before today.

Is there a way to do that?

Kind regards and thanks for any advice on this matter. 

[eazyBI Support · Accepted solution]

Hi,

You could use dynamic filters on time dimension

To try that, click on any date member in the chart, select "Filter time", then choose "<" and type: today

It should hide any other time member after yesterday.

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

Kind regards,

Martins Vanags / support@eazybi.com

[atlassian-consulting@e-core.com]

Hi Martins, thanks for the answer.

The thing is, I need the whole sprint time to show up.

I just need a way to filter the story points measure so that it does not show info after the current date =(

Is there a way to do that? 

[eazyBI Support]

Hi,

Then you could try using this following code when creating your user-defined calculated measure. But then you should ensure that "Hide empty" is turned off, otherwise it would hide these dates anyway as formula return 0 for these dates after 01.sep.

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

Kind regards,

Martins

CASE WHEN
DateCompare([Time].CurrentHierarchyMember.StartDate,'1 day ago')=-1
THEN
Cache(
  Sum({PreviousPeriods([Time].CurrentHierarchyMember),
      [Time].CurrentHierarchyMember},
    [Measures].[Story Points resolved]
  )
)
END

[atlassian-consulting@e-core.com]

Thanks Martins, it worked great!