Is it possible to make one of the lines in an eazyBI line Chart stop at todays date?

[Alexis Bueno]

I want to have 1 of my lines on my line chart stop at the current date while all of the other lines continue through the end of my filtered date on the chart. Does anyone know of a way to make a line in eazyBI do this?

[Lauma Cīrule · Accepted solution]

Hi Alexis!

It would be possible to create a new calculated member that compares if the Time we are currently looking is before Now and only then return the measure value. 

Please see the following example for calculated member that shows Open issues only until today 

CASE 
  WHEN DateCompare(
    [Time].CurrentHierarchyMember.StartDate, Now()) <= 0
  THEN Val([Measures].[Open issues])
  WHEN [Time].CurrentHierarchyMember IS [Time].DefaultMember
  THEN Val([Measures].[Open issues])
END

Let me know if you have additional questions!
Lauma / support@eazybi.com 

[Alexis Bueno]

Hey Lauma,

Thank you very much for your help that is what I needed!

Alexis