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