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
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.
–annotations.group= Predicted by issues
– projects starts at the moment when the first issue is resolved from any In progress status
([Measures].[Transition from first timestamp],
[Transition status.Category].[In Progress],
– old version
– – First date with issues resolved will be project Start date
– [Measures].[Issues resolved] > 0
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
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