Issues Created Count by Status Category?

julia_lam · September 10, 2021, 5:21pm

Hi! Is there a way to create a calculated member in the measures dimension to count the number of issues in specific status categories?

I’m avoiding using the Status as a page to filter by as it times out my report.

Looking to include Count of issues in To Do and In Progress.

ilze.leite · September 16, 2021, 7:22am

Yes, you may create a calculated measure (in Measure), where you would sum issues count over the set of statuses or status categories:

Sum(
 {[Status.Category].[To Do],
  [Status.Category].[In Progress]},
[Measures].[Issues created]
)

julia_lam · September 23, 2021, 8:07pm

Thank you @ilze.leite !