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