[EazyBI] adding a vertical line closest to zero

Marc-Andre Jargstorff

I have a burndown chart and would like to add a vertical line right after the number of issues falls below 0

I have tried this but it creates a vertical line for every entry that is below 0

Case when
[Measures].[Burndown] < 0
then 'Zero'
end

The calculated member neeeds to be dynamic since it will be used in several burndown chart.

How can I have a calculated member that add a word for the first entry below 0?

Marc-Andre Jargstorff

ok, I figured out how to do it but it doesnt do it for all of the columns that are under the measure. Anybody know why?

Solution:

--annotations.group=Vertical Timelines
Case when
[Measures].[Burndown - Based on last 28 entries] < 0 AND 
([Measures].[Burndown - Based on last 28 entries],
 [Time].CurrentHierarchyMember.PrevMember) > 0
then 'ZBR'
end