Analysis of OSM events in Bugzilla

Date and time of the report: 2025-02-10 05:00:04.965614

Analysed period: 2020-07-01 to 2025-02-10.

Bugs considered recent: Since 2025-01-20.

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:

12

Bugs present in multiple branches:

	BUG_DESCRIPTION	NUM_BRANCHES	RELEASE	MODULE	TIMESTAMP

Number of bugs per module

AGE	CURRENT	RECENT	Total
MODULE
IM-NBI	4	1	5
LCM	5	1	6
Robot-tests	0	1	1
Total	9	3	12

2.2 Age of open bugs

Age vs. state of open bugs (global)

AGE	CURRENT	RECENT	Total
VALUE
OPEN-UNCONFIRMED	3	0	3
UNCONFIRMED	1	0	1
CONFIRMED	3	3	6
IN_PROGRESS	2	0	2
Total	9	3	12

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	5.0	261.800000	155.674982	100.0	104.00	321.0	327.00	457.0
1	LCM	6.0	159.166667	124.533396	33.0	74.75	116.0	263.75	316.0
2	Robot-tests	1.0	417.000000	NaN	417.0	417.00	417.0	417.00	417.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	2. Open beyond q3	3. Open beyond 2 months	All
MODULE
IM-NBI	1	4	5.0
LCM	1	4	5.0
Robot-tests	0	1	1.0
All	2	9	11.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 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	2312	2025-01-23 15:50:58	457	5.0	261.8	155.674982	100.0	104.00	321.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	382	457
1	NaN	2361	2025-01-28 15:37:30	316	2.0	314.5	2.121320	313.0	313.75	314.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2025-01-31 23:59:59	False	303	316

2 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	2025-01-28 15:36:17	417	1.0	417.000000	NaN	417.0	417.00	417.0	...	gerardo.garciadeblas@telefonica.com	2023-12-31 23:59:59	CURRENT	1.0	keywords	RECENT	2025-01-31 23:59:59	False	405	417
1	NaN	2353	2025-01-28 15:32:30	327	5.0	261.800000	155.674982	100.0	104.00	321.0	...	NaN	NaT	NaN	NaN	keywords	RECENT	2025-01-31 23:59:59	False	315	327
2	NaN	2356	2025-01-24 12:09:33	321	5.0	261.800000	155.674982	100.0	104.00	321.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	210	321
3	NaN	2368	2025-01-28 15:37:35	313	2.0	314.500000	2.121320	313.0	313.75	314.5	...	NaN	NaT	NaN	NaN	keywords	RECENT	2025-01-31 23:59:59	False	237	313
4	NaN	2387	2025-01-27 00:00:27	116	3.0	97.666667	31.754265	61.0	88.50	116.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	40	116
5	NaN	2388	2025-01-27 00:00:30	116	3.0	97.666667	31.754265	61.0	88.50	116.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	40	116
6	NaN	2392	2025-01-20 00:00:21	104	5.0	261.800000	155.674982	100.0	104.00	321.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	0	104
7	NaN	2393	2025-01-24 11:57:06	100	5.0	261.800000	155.674982	100.0	104.00	321.0	...	NaN	NaT	NaN	NaN	comment	RECENT	2025-01-31 23:59:59	False	6	100
8	NaN	2397	2024-12-10 08:34:26	61	3.0	97.666667	31.754265	61.0	88.50	116.0	...	NaN	NaT	NaN	NaN	comment	CURRENT	2024-12-31 23:59:59	False	0	61

9 rows × 40 columns

3. Temporal evolution

3.1 Number of open bugs