Hi,
I am wondering what is the best way to calculate Sum of story points in progress in an active Sprint by issue status. Here is what I am using right now and I believe this can be optimized.
([Measures].[Sprint Story Points Commitment], [Status].[Dev in Progress] ) +
([Measures].[Sprint Story Points Commitment], [Status].[In Review] ) +
([Measures].[Sprint Story Points Commitment], [Status].[In Progress] ) +
([Measures].[Sprint Story Points Commitment], [Status].[HOLD] ) +
([Measures].[Sprint Story Points Commitment], [Status].[Peer Review] ) +
([Measures].[Sprint Story Points Commitment], [Status].[Ready for QA] ) +
([Measures].[Sprint Story Points Commitment], [Status].[Deployment in Progress] ) +
([Measures].[Sprint Story Points Commitment], [Status].[QA in Progress] ) +
([Measures].[Sprint Story Points Commitment], [Status].[Ready for Acceptance] )
Note - Sprint Story Points Commitment is a custom measure
Thanks