Rolling up total of missed dates per issues.

[Stephen Casey]

I think this is a common report requirement but I can't find it anywhere.  I have a custom milestone date field in Jira which I'm importing.  I have a calculated field that's being set to 1 or 0 or left blank depending on whether the milestone date is set (0 if not), or if it's before the resolution date (1). 

That attribute shows up fine against individual issues but doesn't total up to time spans or other filters (projects etc..).  I'd like to chart these misses against weeks.  Any idea what I might be doing wrong?

For reference, here's the formula calculating the custom field (in measures):

CASE WHEN not isempty([Measures].[Issue Milestone Date])THEN
 CASE WHEN isempty([Measures].[Issue Resolution Date]) THEN
   CASE WHEN DateDiffDays(Now(), [Measures].[Issue Milestone Date]) < -1 THEN 1 END
 ELSE
 CASE WHEN DateDiffDays([Measures].[Issue Resolution Date], [Measures].[Issue Milestone Date]) < -1 THEN 1 END
 END
ELSE
 0 /* No Milestone Date set */
END