Tickets assigned to DSDS→ Service Type: "User Service Restoration","Security incident","user service request"
Service one ticket: the ticket that user creates in service one
HELIX tickets: One service one ticket will have one to many corresponding tickets in Helix in categories such as WO, INC, and CASE. An INC ticket in Helix is mapped to only one Service one ticket. However, more than one WO tickets can be associated to one service one ticket.
IMPORTANT NOTE: Calculations in Global and Site section only includes corresponding tickets in Helix. However, My ticket sections includes attributes of Service one tickets
WO & INC tickets
Ticket number→ for INC "Incident_Number" and for WO "Request_ID"
Submitter id → "submitter"
Submitter name
user site name → "site"
Resolved date→ for INC "last resolved date" for WO "Completed Date"
"Status"
"Submit date"
Service one link → for incident "DWP_SRID"
"Status_Reason"→ to detect tickets pending user actions
Fastlane → "Escalated Fastlane"
Service one tickets
Missing table in ODS (Anon, Kasemvilas )
Service one reference
Service one ticket title
Submit date
Service one link to Helix tickets (note: corresponding field for INC "DWP_SRID" )
Joints of service one tickets and WO, INC and Case tables
TBD
| Contxet | Indicators/graphs / Fields | Description | Visualization block (view) | Source ODS tables | Technical fiels |
|---|---|---|---|---|---|
| INC | Indicator: Backlog incidents today | The number of incidents excluding the ones with "Status": "Resolved","Closed" AND "Canceled" globally in the back log today | Global | prj-data-dm-dt-dev.ODS.ODS_HLX_0000_F001_I_H_workorder | "Status" |
| INC | Indicator: Submitted incidents today | The number of incidents globally with "Submit date" = today | Global | "Submit date" | |
| INC /WO/ CASE | Indicator: Backlog tickets per site | The number of all tickets excluding the ones with "Status": "Status": "Resolved","Closed" AND "Canceled" per site in the backlog today | Site Site is the site of the user who has logged in | WO prj-data-dm-dt-dev.ODS.ODS_HLX_0000_F001_I_H_workorder INC prj-data-dm-dt-dev.ODS.ODS_HLX_0000_F001_I_H_workorder CASE missing | "Status" "submitter" "site" |
| INC | Indicator: Backlog incident tickets per site | The number of incident tickets excluding the ones with "Status": "Resolved","Closed" AND "Canceled" per site in the backlog today | Site | ||
| WO | Indicator: Backlog workorder tickets per site | The number of workorder tickets excluding the ones with "Status":"Status": "Resolved","Closed" AND "Canceled" per site in the backlog today | Site | ||
| CASE | Indicator: Backlog case tickets per site | The number of case tickets excluding the ones with "Status": "Status": "Resolved","Closed" AND "Canceled" per site in the backlog today | Site | CASE missing | |
| WO | Indicator: Average Time to Resolve per site |
(Note: For INC: "last resolved date", for WO ""Completed Date" to consider. )
| Site | prj-data-dm-dt-dev.ODS.ODS_HLX_0000_F001_I_H_HD_incidents | For INC: "last resolved date", for WO "Completed Date" to consider. |
| INC /WO/ CASE | Indicator: Submitted tickets today per site | The number of all tickets per user site with "Submit date" = today | Site | ||
| INC | Indicator: Submitted incident tickets today per site | The number of incident tickets per user site with "Submit date" = today | Site | ||
| WO | Indicator: Submitted workorder tickets today per site | The number of workorder tickets per user site with "Submit date" = today | Site | ||
| CASE | Indicator: Submitted case tickets today per site | The number of case tickets per user site with "Submit date" = today | Site | ||
| INC /WO/ CASE | Indicator: All my tickets | The number of user tickets | My ticket | ||
| INC /WO/ CASE | Indicator: My pending tickets | Calculation is at Helix ticket level: The number of INC and WO where status "pending" AND "Status_Reason": "Client Action Required" And The number of CASE tickets where status "pending" AND "Status_Reason": "Customer response " | My ticket | Source CASE is not available (S2) | "Status_Reason" "Status" |
| INC /WO | Indicator: My Fastlane tickets | Fastlane is defined at WO and INC ticket level The number of service request ticket for which the corresponding INC or WO in helix is "Escalated Fastlane"= "YES", (not applicable for case tickets) If the Service one ticket refers to WOs in helix, at least one of the WO associated should be "Escalated Fastlane"= "YES" to be counted as Fastlane. | My ticket | "Escalated Fastlane" | |
| INC /WO/ CASE | Service one reference | The ID of the service one ticket. (note: An INC ticket in Helix is mapped to only one Service one ticket. However, more than one WO tickets can be associated to one service one ticket. In this section only represents ticket id at service one level) | My ticket | Missing table | |
| INC /WO/ CASE | Priority | Calculation: if the service one ticket is an INC ticket in helix, "Priority"= the priority of the helix ticket if the service one ticket is WO ticket in helix, "Priority"= Fastlane or Normal based on "Escalated Fastlane" attribute of WO Exception: Incident tickets might become Fastlane. In this situation "Priority"= Fastlane or Normal based on "Escalated Fastlane" attribute of INC | My ticket | ||
| Service on ticket | Status | The status of the service one tickets | My ticket | Missing table | |
| Service on ticket | Description | The title of the service one ticket | My ticket | Missing table | |
| Service one ticket | Submit date | The submit date of the service one ticket | My ticket | Missing table | |
| INC /WO/ CASE | Resolved date | Calculation: if the service one ticket is an INC ticket in helix, "Resolved date"= the "last resolved date" of the INC ticket if the service one ticket refers to one/many WO tickets in helix, "resolved date"= Max "Completed_date" of all WO associated AND all WOs' "status"= "Resolved","Closed" OR "Canceled" | My ticket | Missing table | |
| WO/ CASE | Time to complete | Two scenarios: Actual: Applies on the tickets with Status= "Resolved" AND "Canceled" 1)Calculate the Time to complete by subtracting the 'Submit Date' from the 'last Resolved date' for the ticket. Estimate : Applies on tickets not resolved yet. 1) calculate "Average Time to Resolve per site (MTTR)" (see the calculation above) 2) calculate the days passed since the Submit Date and compare it with the MTTR as the baseline. 3) Specify two states including: "within avg" and "passed avg" as result of comparison
5)Assign Color Codes /visuals: Based on the states identified, assign the appropriate visuals to each pending ticket indicating the likelihood of resolution. | in S2 |