Filter two statuses

Questions & Answers
1

Hello, I would like to ask you, what is the correct syntax to selecting two statuses, like bolded below [Status].[Done] and [Status].[Closed]?
It should show only the sum of story points from the closed sprint for tickets with status done or closed.

-- Story points from issues when a sprint was closed
( [Measures].[Sprint Story point estimate at closing],
  [Transition Field].[Sprint status],
  [Sprint Status].[Closed],
  **([Status].[Done] or [Status].[Closed])**
  [Issue Sprint Status Change].[Active => Closed]
)
2

Hi @mwrobel

Welcome to the Community! :tada:

The first thing you need to understand here is - would you like to filter the issues by their current Status or by the Status that they had at the moment of Sprint closing?

For the current status you should use the standard Status dimension, but for the historic status you should use the Transition Status dimension. You can read more here.

If you want to filter by the current statuses, then you can Aggregate these two Done and Closed statuses together in the Status dimension.

Open the Status dimension, and click “Define new calculated member” and use the following formula:

Aggregate({
  [Status].[Done],
  [Status].[Closed]
})

doneandclosed
doneandclosed1750×1152 224 KB

When this is defined, you can reference this member in your tuple as follows:

-- Story points from issues when a sprint was closed
( [Measures].[Sprint Story point estimate at closing],
  [Transition Field].[Sprint status],
  [Sprint Status].[Closed],
  [Status].[Done and Closed],
  [Issue Sprint Status Change].[Active => Closed]
)

Let me know if this works as expected!
​Best regards,
​Nauris / eazyBI support

3

Yeah, it works, thank you