Report Name: Features Started and Closed per PI Legend: EazyBI count/JQL count iQies | PI3 | PI4 | PI5 | PI6 | PI7 |
---|
Implementing | 104/104 | 129/132 | 105/122 | 199/198 | 73/83 | Done | 196/196 | 132/135 | 93/96 | 106/113 | 16/16 |
Project = "iQIES Program Board " AND issuetype = 10000 AND Status changed to Done during (2022-01-19, 2022-04-19) ORDER BY key DESC
EQRS | PI 14 | PI 15 | PI 16 | PI 17 | PI 18 | PI 19 |
---|
Implementing | 16/16 | 30/30 | 36/36 | 27/29 | 18/21 | 16/16 | Done | 10/10 | 25/25 | 32/32 | 27/31 | 27/29 | 19/19 |
Project = " End-Stage Renal Disease Quality Reporting System" AND issuetype = 10000 AND Status changed to Done during (2021-04-04, 2021-07-20) --Update status and dates of PI
Validation Date : 8/17/2022 Because The eazybi measure was using dateBetween with the actual PI start and end dates, it was not picking up items changed to the Implementing or Done statuses on the defined PI Start and End dates, because it was only looking for items in between those dates, not including them I updated the query to check After the the last minute of the day before the PI, and Before the first minute of the day following the PI. I updated the Eazybi measure and then changed the Jira query to use the BEFORE and AFTER operators rather than the DURING and used matching timestamps in both the measure and the query. I suspect that the DURING operator in Jira is not as high resolution as EazyBi's Datebetween function. Items marked with an asterisk are below the STD threshold, but the low issue count skews the severity of deviation percentage, so they get marked green anyways UpdatedDateBetween function: [Time].[Day].DateMembersBetween('Jan 18 2022 23:59', 'Apr 13 2022 00:01')
Updated Query: Project = EQRS AND issuetype = 10000 AND Status changed to Done AFTER ("2022-01-19 00:01") AND Status changed to Done BEFORE ("2022-04-13 00:01")
iQies | PI3 | PI4 | PI5 | PI6 | PI7 |
---|
Implementing | 104/104 | 129/132 | 123/122 | 123/113 | 83/85 | Done | 196/196 | 132/135 | 97/97 | 115/115 | 16/17* |
EQRS | PI 14 | PI 15 | PI 16 | PI 17 | PI 18 | PI 19 |
---|
Implementing | 16/16 | 30/30 | 36/36 | 32/32 | 21/21 | 16/16 | Done | 10/10 | 25/25 | 32/32 | 33/32 | 33/29 | 19/19 |
|