I what to create a chart with one line for Time Remaining (without closed & resolved status being included) and 1 one with the Actuals (with closed & resolved status)

I what to create a chart with one line for Time Remaining (without closed status included) and 1 one with the Actuals (with closed status included) then I will add the Time Remaining with a tending forecast. This way I do not have to put status in the page an impact both lines.

[Measures].[Remaining estimated hours history] but need to omit any thing in a status of “Closed” or “Resolved”

[Measures].[Remaining estimated hours history]

Cache(
NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),
[Measures].[Remaining estimated hours change]
))
)

This gives me everything but tried several options to remove the status of closed and resolved but seams to be ignored. Any suggests greatly apricated.
FTGraham

My suggestion is a measure of the estimated time minus a tuple of the estimated time with closed stuatus (or whatever you like).
We would have the total minus the part of the closed ones.

[Measures].[Remaining estimated hours history]
-
(
[Measures].[Remaining estimated hours history],
[Status].[Closed]
)

1 Like

Thanks Luis.

Work like I as I was looking for. thanks for grounding me.

Here is the picture of the end result with this in place along with time spend so I can Team(s) Actual (work-logs) vs Remaining Estimated Hours.

1 Like