Set "values = blank" for future dates within sprint

Questions & Answers
1

Hey everyone,

i would like to have a modified version of the “Cumulative Resolved Story Points” Graph.

Status Quo is, that the cumulative story points value is shown even for Dates which are in future (but within the sprint).
I would like to have a Graph which only shows the progress from sprint start until “today”. Is it possible to set values blank, if “todays date is < date member”?

Greetings,

Lars

2

Hi Lars,

You can create a calculated measure that first checks if the current date on Time dimension is before ‘Now’ and only then do the calculation. The following CASE would do the check

CASE WHEN
  DateAfterPeriodEnd(now(),
    [Time].CurrentHierarchyMember) OR
  DateInPeriod(now(), [Time].CurrentHierarchyMember)
THEN ...
END

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