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?
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 / email@example.com
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot