Hello, we have been plotting milestone dates as vertical lines on a burn-up chart (timeline view), by keying in the date manually in the calculated measure. These milestones correspond to Epics, and we’ve discovered that eazyBI can recognize the Epic’s target end dates and plot as vertical lines using the below calculation.
IIF( DateInPeriod([Issue].[Issue].GetMemberByKey('EPIC NAME HERE').GetDate('Target end'), [Time].CurrentHierarchyMember) , [Issue].[Issue].GetMemberByKey('EPIC NAME HERE').GetString('Epic Name'), null )
Because we have a number of Epics, we’d like to not create each of these measures manually, is there a way for eazyBI to identify all the epics and end dates in one formula so that the epics will automatically appear and be updated if they are edited in Jira?
Similar to how “today” is noted below, we’d like all the Epic names to be identified on their target end date with one formula. Please let me know if I can clarify further. Thank you!