QCM06 Issue Log - Advanced

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 20

i Project Team Category

FILTERS Department Responsible Type

ANALYSISTABS

i PROJECT DETAILS

4 Company Company Name

4 Manager Your Name

4 Team CreativeTeam

60 15
24
42%
TOTAL ISSUES CLOSED IN PROGRESS

Issues by Status

24

15

9
6 6

Open In progress Fixed Closed Cancelled


Issues by Department Issues by Team

Department 1 6 Team 1 6

Department 2 21
Team 2 26
Department 3 16
Team 3 9
Department 4 8

Team 4 10
Department 5 9

Department 6 0 Team 5 9

Issues by Category Issues by Type

Category 1 12 Type 1 12

Category 2 20 Type 2 15

Category 3 0 Type 3 6

Category 4 12 Type 4 14

Category 5 16 Type 5 13

Issues by Priority Issues by Complexity

Low 9 Easy 24

Medium 33 Moderate 18

High 18 Complex 18
High 18 Complex 18

ISSUES: OPENED vs CLOSED Year 2023

Opened Closed Total Opened Total Closed Opened (C

0.9

0.8

0.7

0.6

0.5

0.4

0.3

0.2

0.1

0 0 0 0 0 0 0 0 0 0
44927 44958 44986 45017 45047 45078 45108 45139 45170
Severity

Status

Issue Log - Advanced @

i Document Control

¦ Date Created Wed,01-Jan-2020 10:00 AM

¦ Last Updated Wed,02-Jan-2019 02:00 PM

¹ Reviewed On Thu,03-Jan-2019 06:00 PM

Issues by Project

Project 1 3

Project 2 6

Project 3 3

Project 4 6

Project 5 5

Project 6 3

Project 7 16

Project 8 9

Project 9 6

Project 10 3

Issues Assigned to
Issues Assigned to

Person 1 12

Person 2 3

Person 3 6

Person 4 14

Person 5 0

Person 6 9

Person 7 7

Person 8 3

Person 9 0

Person 10 6

Issues by Severity

24 Low 12

18 Medium 30

18 High 18
18 High 18

Primary Series Count

otal Closed Opened (Cum.) Closed (Cum.)

0 0 0 0 0
Total Opened; 0
Total Closed, 0

45139 45170 45200 45231 45261 TOTAL


ID Description Assigned to

1 Issue Title 1 Person 1


2 Issue Title 2 Person 2
3 Issue Title 3 Person 6
4✓ Issue Title 4 Person 1
5 Issue Title 5 Person 4
6 Issue Title 6 Person 10
7 Issue Title 7 Person 6
8 Issue Title 8 Person 10
9✓ Issue Title 9 Person 1
10 Issue Title 10 Person 6
11 Issue Title 11 Person 4
12 Issue Title 12 Person 4
13 Issue Title 13 Person 7
14 ✓ Issue Title 14 Person 8
15 ✓ Issue Title 15 Person 4
16 Issue Title 16 Person 3
17 Issue Title 17 Person 3
18 ✓ Issue Title 18 Person 1
19 Issue Title 19 Person 7
20 Issue Title 20 Person 4
21 Issue Title 21 Person 1
22 Issue Title 22 Person 2
23 Issue Title 23 Person 6
24 ✓ Issue Title 24 Person 1
25 Issue Title 25 Person 4
26 Issue Title 26 Person 10
27 Issue Title 27 Person 6
28 Issue Title 28 Person 10
29 ✓ Issue Title 29 Person 1
30 Issue Title 30 Person 6
31 Issue Title 31 Person 4
32 Issue Title 32 Person 4
33 Issue Title 33 Person 7
34 ✓ Issue Title 34 Person 8
35 ✓ Issue Title 35 Person 4
36 Issue Title 36 Person 3
37 Issue Title 37 Person 3
38 ✓ Issue Title 38 Person 1
39 Issue Title 39 Person 7
40 Issue Title 40 Person 1
41 Issue Title 41 Person 2
42 Issue Title 42 Person 6
43 ✓ Issue Title 43 Person 1
44 Issue Title 44 Person 4
45 Issue Title 45 Person 10
46 Issue Title 46 Person 6
47 Issue Title 47 Person 10
48 ✓ Issue Title 48 Person 1
49 Issue Title 49 Person 6
50 Issue Title 50 Person 4
51 Issue Title 51 Person 4
52 Issue Title 52 Person 7
53 ✓ Issue Title 53 Person 8
54 ✓ Issue Title 54 Person 4
55 Issue Title 55 Person 3
56 Issue Title 56 Person 3
57 ✓ Issue Title 57 Person 1
58 Issue Title 58 Person 7
59 Issue Title 59 Person 4
60 Issue Title 60 Person 7
Project Department Team Category

Project 1 Department 2 Team 3 Category 1


Project 8 Department 3 Team 3 Category 2
Project 10 Department 3 Team 2 Category 5
Project 2 Department 2 Team 4 Category 4
Project 6 Department 5 Team 3 Category 4
Project 7 Department 5 Team 2 Category 1
Project 7 Department 2 Team 1 Category 5
Project 7 Department 4 Team 2 Category 2
Project 2 Department 5 Team 2 Category 2
Project 4 Department 4 Team 5 Category 5
Project 9 Department 2 Team 5 Category 4
Project 5 Department 1 Team 2 Category 5
Project 7 Department 3 Team 4 Category 5
Project 8 Department 1 Team 2 Category 2
Project 8 Department 2 Team 1 Category 4
Project 4 Department 2 Team 4 Category 2
Project 7 Department 2 Team 2 Category 2
Project 9 Department 3 Team 5 Category 1
Project 3 Department 3 Team 2 Category 1
Project 5 Department 4 Team 2 Category 2
Project 1 Department 2 Team 3 Category 1
Project 8 Department 3 Team 3 Category 2
Project 10 Department 3 Team 2 Category 5
Project 2 Department 2 Team 4 Category 4
Project 6 Department 5 Team 3 Category 4
Project 7 Department 5 Team 2 Category 1
Project 7 Department 2 Team 1 Category 5
Project 7 Department 4 Team 2 Category 2
Project 2 Department 5 Team 2 Category 2
Project 4 Department 4 Team 5 Category 5
Project 9 Department 2 Team 5 Category 4
Project 5 Department 1 Team 2 Category 5
Project 7 Department 3 Team 4 Category 5
Project 8 Department 1 Team 2 Category 2
Project 8 Department 2 Team 1 Category 4
Project 4 Department 2 Team 4 Category 2
Project 7 Department 2 Team 2 Category 2
Project 9 Department 3 Team 5 Category 1
Project 3 Department 3 Team 2 Category 1
Project 1 Department 2 Team 3 Category 1
Project 8 Department 3 Team 3 Category 2
Project 10 Department 3 Team 2 Category 5
Project 2 Department 2 Team 4 Category 4
Project 6 Department 5 Team 3 Category 4
Project 7 Department 5 Team 2 Category 1
Project 7 Department 2 Team 1 Category 5
Project 7 Department 4 Team 2 Category 2
Project 2 Department 5 Team 2 Category 2
Project 4 Department 4 Team 5 Category 5
Project 9 Department 2 Team 5 Category 4
Project 5 Department 1 Team 2 Category 5
Project 7 Department 3 Team 4 Category 5
Project 8 Department 1 Team 2 Category 2
Project 8 Department 2 Team 1 Category 4
Project 4 Department 2 Team 4 Category 2
Project 7 Department 2 Team 2 Category 2
Project 9 Department 3 Team 5 Category 1
Project 3 Department 3 Team 2 Category 1
Project 5 Department 4 Team 2 Category 2
Project 7 Department 3 Team 4 Category 5
Type Severity Priority Complexity Progress

Type 4 Low Low Easy 10%


Type 5 Medium Medium Moderate 25%
Type 2 Medium High Complex 50%
Type 3 Medium Medium Easy 100%
Type 2 Low Low Moderate 5%
Type 4 Low High Complex 7%
Type 2 Medium Medium Easy 0%
Type 1 Medium Medium Moderate 25%
Type 4 High High Complex 100%
Type 5 Medium Medium Easy 100%
Type 4 High Medium Moderate 100%
Type 3 High High Complex 10%
Type 5 Medium Medium Easy 0%
Type 2 Medium Low Moderate 100%
Type 5 High High Complex 100%
Type 1 Medium Medium Moderate 0%
Type 2 High Medium Complex 7%
Type 1 High High Easy 100%
Type 1 Low Medium Easy 0%
Type 4 Medium Medium Easy 0%
Type 4 Low Low Easy 10%
Type 5 Medium Medium Moderate 25%
Type 2 Medium High Complex 50%
Type 3 Medium Medium Easy 100%
Type 2 Low Low Moderate 5%
Type 4 Low High Complex 7%
Type 2 Medium Medium Easy 0%
Type 1 Medium Medium Moderate 25%
Type 4 High High Complex 100%
Type 5 Medium Medium Easy 100%
Type 4 High Medium Moderate 100%
Type 3 High High Complex 10%
Type 5 Medium Medium Easy 0%
Type 2 Medium Low Moderate 100%
Type 5 High High Complex 100%
Type 1 Medium Medium Moderate 0%
Type 2 High Medium Complex 7%
Type 1 High High Easy 100%
Type 1 Low Medium Easy 0%
Type 4 Low Low Easy 10%
Type 5 Medium Medium Moderate 25%
Type 2 Medium High Complex 50%
Type 3 Medium Medium Easy 100%
Type 2 Low Low Moderate 5%
Type 4 Low High Complex 7%
Type 2 Medium Medium Easy 0%
Type 1 Medium Medium Moderate 25%
Type 4 High High Complex 100%
Type 5 Medium Medium Easy 100%
Type 4 High Medium Moderate 100%
Type 3 High High Complex 10%
Type 5 Medium Medium Easy 0%
Type 2 Medium Low Moderate 100%
Type 5 High High Complex 100%
Type 1 Medium Medium Moderate 0%
Type 2 High Medium Complex 7%
Type 1 High High Easy 100%
Type 1 Low Medium Easy 0%
Type 4 Medium Medium Easy 0%
Type 5 Medium Medium Easy 0%
Date Created Date Resolved

Status Opened On Date Identified Date Reviewed Closed On

In progress 1-Jan-20 7-Jan-20 15-Jan-20 31-Jan-20


In progress 6-Jan-20 15-Jan-20 23-Jan-20 4-Feb-20
In progress 11-Jan-20 21-Jan-20 25-Jan-20 14-Feb-20
Closed 16-Jan-20 23-Jan-20 1-Feb-20 16-Feb-20
In progress 21-Jan-20 27-Jan-20 1-Feb-20 14-Feb-20
In progress 26-Jan-20 29-Jan-20 3-Feb-20 23-Feb-20
Cancelled 31-Jan-20 10-Feb-20 16-Feb-20 4-Mar-20
In progress 5-Feb-20 15-Feb-20 23-Feb-20 9-Mar-20
Closed 10-Feb-20 16-Feb-20 25-Feb-20 11-Mar-20
Fixed 15-Feb-20 19-Feb-20 22-Feb-20 9-Mar-20
Fixed 20-Feb-20 25-Feb-20 4-Mar-20 16-Mar-20
In progress 25-Feb-20 4-Mar-20 12-Mar-20 27-Mar-20
Open 1-Mar-20 6-Mar-20 10-Mar-20 28-Mar-20
Closed 6-Mar-20 9-Mar-20 19-Mar-20 4-Apr-20
Closed 11-Mar-20 20-Mar-20 26-Mar-20 11-Apr-20
Open 16-Mar-20 19-Mar-20 29-Mar-20 11-Apr-20
In progress 21-Mar-20 27-Mar-20 5-Apr-20 17-Apr-20
Closed 26-Mar-20 2-Apr-20 12-Apr-20 25-Apr-20
Cancelled 31-Mar-20 8-Apr-20 12-Apr-20 1-May-20
Open 5-Apr-20 9-Apr-20 19-Apr-20 23-Apr-20
In progress 10-Apr-20 15-Apr-20 23-Apr-20 11-May-20
In progress 15-Apr-20 24-Apr-20 3-May-20 16-May-20
In progress 20-Apr-20 25-Apr-20 2-May-20 19-May-20
Closed 25-Apr-20 1-May-20 8-May-20 27-May-20
In progress 30-Apr-20 3-May-20 8-May-20 27-May-20
In progress 5-May-20 9-May-20 13-May-20 1-Jun-20
Cancelled 10-May-20 17-May-20 21-May-20 2-Jun-20
In progress 15-May-20 20-May-20 25-May-20 11-Jun-20
Closed 20-May-20 25-May-20 28-May-20 12-Jun-20
Fixed 25-May-20 28-May-20 2-Jun-20 23-Jun-20
Fixed 30-May-20 2-Jun-20 6-Jun-20 5-Jul-20
In progress 4-Jun-20 12-Jun-20 16-Jun-20 11-Jul-20
Open 9-Jun-20 14-Jun-20 19-Jun-20 26-Jun-20
Closed 14-Jun-20 22-Jun-20 1-Jul-20 20-Jul-20
Closed 19-Jun-20 24-Jun-20 1-Jul-20 14-Jul-20
Open 24-Jun-20 27-Jun-20 6-Jul-20 21-Jul-20
In progress 29-Jun-20 8-Jul-20 18-Jul-20 24-Jul-20
Closed 4-Jul-20 13-Jul-20 21-Jul-20 7-Aug-20
Cancelled 9-Jul-20 17-Jul-20 23-Jul-20 30-Jul-20
In progress 14-Jul-20 21-Jul-20 25-Jul-20 4-Aug-20
In progress 19-Jul-20 28-Jul-20 31-Jul-20 18-Aug-20
In progress 24-Jul-20 2-Aug-20 8-Aug-20 23-Aug-20
Closed 29-Jul-20 2-Aug-20 11-Aug-20 25-Aug-20
In progress 3-Aug-20 9-Aug-20 12-Aug-20 9-Sep-20
In progress 8-Aug-20 12-Aug-20 19-Aug-20 7-Sep-20
Cancelled 13-Aug-20 23-Aug-20 28-Aug-20 17-Sep-20
In progress 18-Aug-20 22-Aug-20 29-Aug-20 11-Sep-20
Closed 23-Aug-20 26-Aug-20 4-Sep-20 17-Sep-20
Fixed 28-Aug-20 6-Sep-20 9-Sep-20 25-Sep-20
Fixed 2-Sep-20 5-Sep-20 14-Sep-20 30-Sep-20
In progress 7-Sep-20 10-Sep-20 15-Sep-20 28-Sep-20
Open 12-Sep-20 18-Sep-20 22-Sep-20 10-Oct-20
Closed 2-Jan-20 8-Jan-20 11-Jan-20 2-Feb-20
Closed 7-Jan-20 12-Jan-20 16-Jan-20 12-Feb-20
Open 12-Jan-20 18-Jan-20 21-Jan-20 31-Jan-20
In progress 17-Jan-20 26-Jan-20 4-Feb-20 16-Feb-20
Closed 22-Jan-20 31-Jan-20 8-Feb-20 22-Feb-20
Cancelled 27-Jan-20 3-Feb-20 9-Feb-20 19-Feb-20
Open 2-Jan-20 11-Jan-20 17-Jan-20 3-Feb-20
Open 7-Jan-20 11-Jan-20 21-Jan-20 26-Jan-20
Formula
Resolution Comments DBFilter

Notes or Results of the Resolution Additional Comments here 1


Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Notes or Results of the Resolution Additional Comments here 1
Project Department Team

Project 1 Department 1 Team 1


Project 2 Department 2 Team 2
Project 3 Department 3 Team 3
Project 4 Department 4 Team 4
Project 5 Department 5 Team 5
Project 6 Department 6
Project 7
Project 8
Project 9
Project 10
Responsible Category Type Priority Complexity Severity Status

Person 1 Category 1 Type 1 Low Easy Low Open


Person 2 Category 2 Type 2 Medium Moderate Medium In progress
Person 3 Category 3 Type 3 High Complex High Fixed
Person 4 Category 4 Type 4 Closed
Person 5 Category 5 Type 5 Cancelled
Person 6
Person 7
Person 8
Person 9
Person 10
Formula
Project Department Team Assigned to Category Type
Project Stats Department Stats Team Stats Responsible Stats Category Stats Type Stats

3 6 6 12 12 12
6 21 26 3 20 15
3 16 9 6 0 6
6 8 10 14 12 14
5 9 9 0 16 13
3 0 9
16 7
9 3
6 0
3 6
Priority ComplexitySeverity Status
Priority Stats ComplexitySeverity StStatus Stats

9 24 12 9
33 18 30 24
18 18 18 6
15
6

You might also like