Dear esteemed eazyBI team,
I created a report based on the requirements provided to me but it’s very slow in loading and sometimes eazyBI crashes on opening the report for the first time, so I need your help to do a health check and let me know how I can improve the measures to make the report much faster and avoid crashes
Notes
- Please note that I’m very new to eazyBI and this is my first report
- We are using eazyBI for Jira on premise and Jira is Data Center edition
Business Requirements
Title: Team completion performance report
- Create a report on team tasks for a specific project (here I added to the Pages Project and Issue type so I can filter the report data set to show only Jira issues in this project and also with issue type task only to improve performance)
- For each team member (assignee) in rows show the following stats for only assigned tasks
-Total Number of tasks assigned
-Total Number of Open tasks (status = open or in-progress or reopened or on-hold)
-Total Number of Completed tasks (status = Ready for validation or validated or done or dropped and progress = 100)
-Total Number of tasks completed on-time (Baseline end date = End date.)
-Total Number of tasks delayed (Baselined end date < End date)
-Completion Score based on following table
Below are my measures which I believe are causing the slowness in the report:
Completed Tasks
(
[Status].[Ready for Validation] + [Status].[Validated] + [Status].[Done] + [Status].[Dropped]
)
Open Tasks
(
[Status].[Open]+[Status].[Reopened]+[Status].[In Progress]+[Status].[On Hold]
)
Ontime Tasks
Count
(
Filter
(
Descendants([Issue].CurrentMember,[Issue].[Issue])
,
[Measures].[Issues created] > 0
AND
(
[Measures].[Issue status] = "Ready for Validation"
OR
[Measures].[Issue status] = "Validated"
OR
[Measures].[Issue status] = "Done"
OR
[Measures].[Issue status] = "Dropped"
)
AND
[Measures].[Issue Progress] = 100
AND
DateCompare
(
[Measures].[Issue Baseline end date]
,
[Measures].[Issue End Date.]
) >= 0
)
)
Delayed Tasks
Count
(
Filter
(
Descendants([Issue].CurrentMember,[Issue].[Issue])
,
[Measures].[Issues created] > 0
AND
(
[Measures].[Issue status] = "Ready for Validation"
OR
[Measures].[Issue status] = "Validated"
OR
[Measures].[Issue status] = "Done"
OR
[Measures].[Issue status] = "Dropped"
)
AND
[Measures].[Issue Progress] = 100
AND
DateCompare
(
[Measures].[Issue Baseline end date]
,
[Measures].[Issue End Date.]
) < 0
)
)
Task Completion Score
CASE
WHEN
[Measures].[Delayed Tasks] = 0
THEN
1
WHEN
[Measures].[Delayed Tasks] > 0
AND
[Measures].[Delayed Tasks] / [Measures].[Completed Tasks] > 0.95
THEN
1
WHEN
[Measures].[Delayed Tasks] > 0
AND
[Measures].[Delayed Tasks] / [Measures].[Completed Tasks] < 0.95
AND
[Measures].[Delayed Tasks] / [Measures].[Completed Tasks] >= 0.9
THEN
0.95
WHEN
[Measures].[Delayed Tasks] > 0
AND
[Measures].[Delayed Tasks] / [Measures].[Completed Tasks] < 0.9
AND
[Measures].[Delayed Tasks] / [Measures].[Completed Tasks] >= 0.85
THEN
0.75
WHEN
[Measures].[Delayed Tasks] > 0
AND
[Measures].[Delayed Tasks] / [Measures].[Completed Tasks] < 0.85
AND
[Measures].[Delayed Tasks] / [Measures].[Completed Tasks] >= 0.80
THEN
0.5
ELSE
0
END
Thanks in advance for your quick response and support to fix the performance issue in this report