Changing Measures from Resolved powered to Closed powered

I’d like to utilize the project prediction report but base it off of my closed status, which in my case does not get a resolution timestamp. Can this be done, if so how? My attempts to update have been producing blank reports

Hi @JohnMichael_Talarico

Welcome to eazyBI community!
After you imported the Project Prediction report from our demo account and defined “Closed” statuses, you could manually update calculated measures and replacing “Issues resolved” measure with “Issues closed” measure everywhere in the code for measures used or referenced in your report.

Martins / eazyBI support

Thanks for the reply. I think I may be stuck on updating other dependent measures in this though. Specifically, in order to get “predicted on” you must update “Project start date” which appears to get timestamps from resolutions.

see:
–annotations.group= Predicted by issues
– projects starts at the moment when the first issue is resolved from any In progress status
DateWithoutTime(TimestampToDate(
([Measures].[Transition from first timestamp],
[Resolution].[(unresolved)],
[Transition Field].[Resolution],
[Transition status.Category].[In Progress],
[Time].CurrentHierarchy.DefaultMember)
))
– old version
– Cache(
– – First date with issues resolved will be project Start date
– Filter([Time].CurrentHierarchy.Levels(‘Day’).Members,
– [Measures].[Issues resolved] > 0
– ).Item(0).StartDate
– )

What would need to change here in order to not be dependent on resolution? I’ve tried a few things but I’m guessing my MDX isn’t cutting it

Hi,

Try this code:

Cache(
-- First date with issues resolved will be project Start date
Filter([Time].CurrentHierarchy.Levels('Day').Members,
      [Measures].[Issues closed] > 0
      ).Item(0).StartDate 
)

Martins / eazyBI