% of Resolved Issues by Component

Hello EasyBI community,

I am new to Easy BI, and just now now learning. I am trying to create a report that will calculate the % of resolved issues with a particular component against all resolved issues by project. Preferably filtered by month/quarter.

Note:
Multiple projects have component “A”
Resolved can be either “fixed” or “done”

Hi @Ashleigh
Welcome to eazyBI community.
In this case, you could create a new calculated measure with % formatting to calculate the expected results.

CASE WHEN
[Measures].[Issues resolved]>0
THEN
(
  [Measures].[Issues resolved],
  [Project].[ProjectName].[Component]
)
/
[Measures].[Issues resolved]
END

See attached images
Martins / eazyBI team


Thank you! This works great for one project. Is there a way to update it to show across multiple projects?

Hi,

Try this more general code to cover more than 1 project:

CASE WHEN
[Measures].[Issues resolved]>0
THEN
Aggregate(
Filter(
[Project].[Component].Members,
[Project].CurrentMember.Name = "A"
),
[Measures].[Issues resolved]
)
/
[Measures].[Issues resolved]
END

Martins / eazyBI team