Analysis of OSM events in Bugzilla

Date and time of the report: 2024-12-09 05:00:05.616574

Analysed period: 2020-07-01 to 2024-12-09.

Bugs considered recent: Since 2024-11-18.

1. Imports and cleans raw source data with all Bugzilla events

DONE

2. Current state of open bugs

2.1 Number of open bugs

Total number of open bugs:

31

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
IM-NBI	12	3	15
LCM	2	4	6
NG-SA	5	0	5
NG-UI	1	1	2
RO	2	0	2
Robot-tests	1	0	1
Total	23	8	31

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	12	1	13
UNCONFIRMED	4	0	4
CONFIRMED	7	4	11
IN_PROGRESS	0	3	3
Total	23	8	31

Age distribution per module

NOTE: To see how a boxplot representation works, you may refer to this article.

Table with distributions of ages of currently open bugs:

	MODULE	count	mean	std	min	25%	50%	75%	max
0	IM-NBI	15.0	196.266667	118.018441	34.0	85.50	215.0	261.0	394.0
1	LCM	6.0	152.166667	108.272650	53.0	53.25	152.0	250.0	253.0
2	NG-SA	5.0	53.000000	0.000000	53.0	53.00	53.0	53.0	53.0
3	NG-UI	2.0	134.000000	165.462987	17.0	75.50	134.0	192.5	251.0
4	RO	2.0	42.000000	12.727922	33.0	37.50	42.0	46.5	51.0
5	Robot-tests	1.0	354.000000	NaN	354.0	354.00	354.0	354.0	354.0

2.3 Outliers

Four types of bug age outliers are identified:

1. Too old bugs.
2. Pure outliers for boxplot: Beyond Q3+1.5IQR for the MDG.
3. Beyond 3rd quartile of ages.
4. Age beyond 2 months.

Recommendations file does not exist.

Summary table of outliers:

AGE	1. Open outliers	2. Open beyond q3	3. Open beyond 2 months	All
MODULE
IM-NBI	2	2	8	12.0
LCM	0	1	2	3.0
NG-UI	0	0	1	1.0
RO	0	1	0	1.0
Robot-tests	0	0	1	1.0
All	2	4	12	18.0

Outlier details

Too old bugs:

	RECOMMENDATION	BUG_ID	BUG_DESCRIPTION	ISSUER	CREATION_TIME	CREATION_AGE	MONTH	STATE	STATE_UPDATE_TIME	STATE_UPDATE_AGE	...	LAST_ASSIGNMENT_MONTH	LAST_ASSIGNMENT_AGE	OWNER_CHANGES	LAST_EVENT	LAST_EVENT_TIME	LAST_EVENT_AGE	LAST_EVENT_MONTH	SOLVED	BUG_RESOLUTION_TIME	TIME_SINCE_CREATION

0 rows × 29 columns

Pure outliers:

	RECOMMENDATION	BUG_ID	LAST_EVENT_TIME	Time bug open (days)	count	mean	std	min	25%	50%	...	OWNER	LAST_ASSIGNMENT_MONTH	LAST_ASSIGNMENT_AGE	OWNER_CHANGES	LAST_EVENT	LAST_EVENT_AGE	LAST_EVENT_MONTH	SOLVED	BUG_RESOLUTION_TIME	TIME_SINCE_CREATION
0	NaN	2312	2024-11-27 04:48:55	394	12.0	228.25	109.481526	37.0	207.5	236.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-11-30 23:59:59.000000	False	382	394
1	NaN	2314	2024-12-01 00:00:12	390	12.0	228.25	109.481526	37.0	207.5	236.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-12-09 04:00:05.648129	False	224	390

2 rows × 40 columns

Beyond Q3:

	RECOMMENDATION	BUG_ID	LAST_EVENT_TIME	Time bug open (days)	count	mean	std	min	25%	50%	...	OWNER	LAST_ASSIGNMENT_MONTH	LAST_ASSIGNMENT_AGE	OWNER_CHANGES	LAST_EVENT	LAST_EVENT_AGE	LAST_EVENT_MONTH	SOLVED	BUG_RESOLUTION_TIME	TIME_SINCE_CREATION
0	NaN	2351	2024-12-02 18:36:01	265	12.0	228.250000	109.481526	37.0	207.5	236.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-12-09 04:00:05.648129	False	220	265
1	NaN	2361	2024-11-26 03:00:17	253	3.0	251.000000	1.732051	250.0	250.0	250.0	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-11-30 23:59:59.000000	False	240	253
2	NaN	2381	2024-11-13 00:00:16	87	3.0	68.333333	29.771351	34.0	59.0	84.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-11-30 23:59:59.000000	False	0	87
3	NaN	2391	2024-10-18 13:58:41	51	2.0	42.000000	12.727922	33.0	37.5	42.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-10-31 23:59:59.000000	False	0	51

4 rows × 40 columns

Beyond 2 months:

	RECOMMENDATION	BUG_ID	LAST_EVENT_TIME	Time bug open (days)	count	mean	std	min	25%	50%	...	OWNER	LAST_ASSIGNMENT_MONTH	LAST_ASSIGNMENT_AGE	OWNER_CHANGES	LAST_EVENT	LAST_EVENT_AGE	LAST_EVENT_MONTH	SOLVED	BUG_RESOLUTION_TIME	TIME_SINCE_CREATION
0	NaN	2331	2024-12-01 00:00:15	354	1.0	354.000000	NaN	354.0	354.0	354.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59.000000	CURRENT	1.0	comment	RECENT	2024-12-09 04:00:05.648129	False	230	354
1	NaN	2353	2024-10-21 11:00:34	264	12.0	228.250000	109.481526	37.0	207.5	236.5	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-10-31 23:59:59.000000	False	216	264
2	NaN	2356	2024-11-05 15:39:41	258	12.0	228.250000	109.481526	37.0	207.5	236.5	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-11-30 23:59:59.000000	False	210	258
3	NaN	2357	2024-11-26 17:01:34	258	12.0	228.250000	109.481526	37.0	207.5	236.5	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-11-30 23:59:59.000000	False	210	258
4	NaN	2366	2024-12-03 16:37:50	251	1.0	251.000000	NaN	251.0	251.0	251.0	...	sandhya.j@tataelxsi.co.in	2024-12-09 04:00:05.648129	RECENT	1.0	cc	RECENT	2024-12-09 04:00:05.648129	False	182	251
5	NaN	2368	2024-11-26 04:54:44	250	3.0	251.000000	1.732051	250.0	250.0	250.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2024-11-30 23:59:59.000000	False	237	250
6	NaN	2369	2024-10-21 11:00:08	250	3.0	251.000000	1.732051	250.0	250.0	250.0	...	NaN	NaT	NaN	NaN	bug_status	CURRENT	2024-10-31 23:59:59.000000	False	201	250
7	NaN	2371	2024-10-21 11:01:37	215	12.0	228.250000	109.481526	37.0	207.5	236.5	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2024-10-31 23:59:59.000000	False	166	215
8	NaN	2372	2024-10-21 11:01:52	215	12.0	228.250000	109.481526	37.0	207.5	236.5	...	NaN	NaT	NaN	NaN	resolution	CURRENT	2024-10-31 23:59:59.000000	False	166	215
9	NaN	2375	2024-11-25 12:12:47	214	12.0	228.250000	109.481526	37.0	207.5	236.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-11-30 23:59:59.000000	False	201	214
10	NaN	2378	2024-11-26 16:41:07	188	12.0	228.250000	109.481526	37.0	207.5	236.5	...	NaN	NaT	NaN	NaN	bug_status	RECENT	2024-11-30 23:59:59.000000	False	176	188
11	NaN	2382	2024-11-16 00:00:24	84	3.0	68.333333	29.771351	34.0	59.0	84.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-11-30 23:59:59.000000	False	0	84

12 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs