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
