**************************************************************************** Location : Tableau Server Host : http://bnbrepository9/#/ Path : Tableau Samples/Problem Report **************************************************************************** Workbook Information Author: Unknown Embedded Datasources Datasource: dev10906 Connection Data Sources Data Source: dev10906 Attributes authType: custom authentication: yes channel: https class: webdata-direct:ServiceNowITSM-ServiceNowITSM connectionData: {"connectorName":"ServiceNow ITSM","apiScheme":"https","apiDomain":"service-now.com","apiVersion":"v1","pagination":{"batchSize":500},"userFilters":{"dateRange":30},"authStrategy":"basic","selectedFilter":"dateRange"} connectionName: ven01911 filename: servicenow.html path: /servicenow/servicenow/1/ port: 443 server: connectors.tableau.com username: {"user":"","apiInstance":""} workgroup-auth-mode: prompt Tables Table: Problem Database Object: [problem] Connection: dev10906 Table: Group Database Object: [sys_user_group] Connection: dev10906 Table: Incident Database Object: [incident] Connection: dev10906 Dimension Group Dimension: Active (Group) Role: Discrete Dimension Remote Column: [Group].[active] Data Type: boolean Dimension: Cost center Role: Discrete Dimension Remote Column: [Group].[cost_center] Data Type: string Dimension: Default assignee Role: Discrete Dimension Remote Column: [Group].[default_assignee] Data Type: string Dimension: Description (Group) Role: Discrete Dimension Remote Column: [Group].[description] Data Type: string Dimension: Group email Role: Discrete Dimension Remote Column: [Group].[email] Data Type: string Dimension: Exclude manager Role: Discrete Dimension Remote Column: [Group].[exclude_manager] Data Type: boolean Dimension: Include members Role: Discrete Dimension Remote Column: [Group].[include_members] Data Type: boolean Dimension: Manager Role: Discrete Dimension Remote Column: [Group].[manager] Data Type: string Dimension: Name Role: Discrete Dimension Remote Column: [Group].[name] Data Type: string Dimension: Parent (Group) Role: Discrete Dimension Remote Column: [Group].[parent] Data Type: string Dimension: Roles Role: Discrete Dimension Remote Column: [Group].[roles] Data Type: string Dimension: Source Role: Discrete Dimension Remote Column: [Group].[source] Data Type: string Dimension: Created by (Group) Role: Discrete Dimension Remote Column: [Group].[sys_created_by] Data Type: string Dimension: Created (Group) Role: Discrete Dimension Remote Column: [Group].[sys_created_on] Data Type: datetime Dimension: Sys ID (Group) Role: Discrete Dimension Remote Column: [Group].[sys_id] Data Type: string Dimension: Updated by (Group) Role: Discrete Dimension Remote Column: [Group].[sys_updated_by] Data Type: string Dimension: Updated (Group) Role: Discrete Dimension Remote Column: [Group].[sys_updated_on] Data Type: datetime Dimension: Type Role: Discrete Dimension Remote Column: [Group].[type] Data Type: string Dimension: u_ Role: Discrete Dimension Remote Column: [Group].[u_lu2] Data Type: string Dimension: Lucha Role: Discrete Dimension Remote Column: [Group].[u_lucha] Data Type: string Dimension: u Role: Discrete Dimension Remote Column: [Group].[u_u] Data Type: string Incident Dimension: Active (Incident) Role: Discrete Dimension Remote Column: [Incident].[active] Data Type: boolean Dimension: Activity due (Incident) Role: Discrete Dimension Remote Column: [Incident].[activity_due] Data Type: datetime Dimension: Additional assignee list (Incident) Role: Discrete Dimension Remote Column: [Incident].[additional_assignee_list] Data Type: string Dimension: Approval (Incident) Role: Discrete Dimension Remote Column: [Incident].[approval] Data Type: string Dimension: Approval history (Incident) Role: Discrete Dimension Remote Column: [Incident].[approval_history] Data Type: string Dimension: Approval set (Incident) Role: Discrete Dimension Remote Column: [Incident].[approval_set] Data Type: datetime Dimension: Assigned to (Incident) Role: Discrete Dimension Remote Column: [Incident].[assigned_to] Data Type: string Dimension: Assignment group (Incident) Role: Discrete Dimension Remote Column: [Incident].[assignment_group] Data Type: string Dimension: Business duration (Incident) Role: Discrete Dimension Remote Column: [Incident].[business_duration] Data Type: datetime Dimension: Business service (Incident) Role: Discrete Dimension Remote Column: [Incident].[business_service] Data Type: string Dimension: Duration (Incident) Role: Discrete Dimension Remote Column: [Incident].[calendar_duration] Data Type: datetime Dimension: Caller Role: Discrete Dimension Remote Column: [Incident].[caller_id] Data Type: string Dimension: Category Role: Discrete Dimension Remote Column: [Incident].[category] Data Type: string Dimension: Caused by Change Role: Discrete Dimension Remote Column: [Incident].[caused_by] Data Type: string Dimension: Close code Role: Discrete Dimension Remote Column: [Incident].[close_code] Data Type: string Dimension: Close notes (Incident) Role: Discrete Dimension Remote Column: [Incident].[close_notes] Data Type: string Dimension: Closed (Incident) Role: Discrete Dimension Remote Column: [Incident].[closed_at] Data Type: datetime Dimension: Closed by (Incident) Role: Discrete Dimension Remote Column: [Incident].[closed_by] Data Type: string Dimension: Configuration item (Incident) Role: Discrete Dimension Remote Column: [Incident].[cmdb_ci] Data Type: string Dimension: Additional comments (Incident) Role: Discrete Dimension Remote Column: [Incident].[comments] Data Type: string Dimension: Comments and Work notes (Incident) Role: Discrete Dimension Remote Column: [Incident].[comments_and_work_notes] Data Type: string Dimension: Company (Incident) Role: Discrete Dimension Remote Column: [Incident].[company] Data Type: string Dimension: Contact type (Incident) Role: Discrete Dimension Remote Column: [Incident].[contact_type] Data Type: string Dimension: Correlation display (Incident) Role: Discrete Dimension Remote Column: [Incident].[correlation_display] Data Type: string Dimension: Correlation ID (Incident) Role: Discrete Dimension Remote Column: [Incident].[correlation_id] Data Type: string Dimension: Delivery plan (Incident) Role: Discrete Dimension Remote Column: [Incident].[delivery_plan] Data Type: string Dimension: Delivery task (Incident) Role: Discrete Dimension Remote Column: [Incident].[delivery_task] Data Type: string Dimension: Description (Incident) Role: Discrete Dimension Remote Column: [Incident].[description] Data Type: string Dimension: Due date (Incident) Role: Discrete Dimension Remote Column: [Incident].[due_date] Data Type: datetime Dimension: Expected start (Incident) Role: Discrete Dimension Remote Column: [Incident].[expected_start] Data Type: datetime Dimension: Follow up (Incident) Role: Discrete Dimension Remote Column: [Incident].[follow_up] Data Type: datetime Dimension: Group list (Incident) Role: Discrete Dimension Remote Column: [Incident].[group_list] Data Type: string Dimension: Knowledge (Incident) Role: Discrete Dimension Remote Column: [Incident].[knowledge] Data Type: boolean Dimension: Location (Incident) Role: Discrete Dimension Remote Column: [Incident].[location] Data Type: string Dimension: Made SLA (Incident) Role: Discrete Dimension Remote Column: [Incident].[made_sla] Data Type: boolean Dimension: Number (Incident) Role: Discrete Dimension Remote Column: [Incident].[number] Data Type: string Dimension: Opened (Incident) Role: Discrete Dimension Remote Column: [Incident].[opened_at] Data Type: datetime Dimension: Opened by (Incident) Role: Discrete Dimension Remote Column: [Incident].[opened_by] Data Type: string Dimension: Parent (Incident) Role: Discrete Dimension Remote Column: [Incident].[parent] Data Type: string Dimension: Parent Incident Role: Discrete Dimension Remote Column: [Incident].[parent_incident] Data Type: string Dimension: Problem Role: Discrete Dimension Remote Column: [Incident].[problem_id] Data Type: string Dimension: Resolved Role: Discrete Dimension Remote Column: [Incident].[resolved_at] Data Type: datetime Dimension: Resolved by Role: Discrete Dimension Remote Column: [Incident].[resolved_by] Data Type: string Dimension: Change Request Role: Discrete Dimension Remote Column: [Incident].[rfc] Data Type: string Dimension: Short description (Incident) Role: Discrete Dimension Remote Column: [Incident].[short_description] Data Type: string Dimension: SLA due (Incident) Role: Discrete Dimension Remote Column: [Incident].[sla_due] Data Type: datetime Dimension: Subcategory Role: Discrete Dimension Remote Column: [Incident].[subcategory] Data Type: string Dimension: Task type (Incident) Role: Discrete Dimension Remote Column: [Incident].[sys_class_name] Data Type: string Dimension: Created by (Incident) Role: Discrete Dimension Remote Column: [Incident].[sys_created_by] Data Type: string Dimension: Created (Incident) Role: Discrete Dimension Remote Column: [Incident].[sys_created_on] Data Type: datetime Dimension: Domain (Incident) Role: Discrete Dimension Remote Column: [Incident].[sys_domain] Data Type: string Dimension: Domain Path (Incident) Role: Discrete Dimension Remote Column: [Incident].[sys_domain_path] Data Type: string Dimension: Sys ID (Incident) Role: Discrete Dimension Remote Column: [Incident].[sys_id] Data Type: string Dimension: Updated by (Incident) Role: Discrete Dimension Remote Column: [Incident].[sys_updated_by] Data Type: string Dimension: Updated (Incident) Role: Discrete Dimension Remote Column: [Incident].[sys_updated_on] Data Type: datetime Dimension: Time worked (Incident) Role: Discrete Dimension Remote Column: [Incident].[time_worked] Data Type: string Dimension: Upon approval (Incident) Role: Discrete Dimension Remote Column: [Incident].[upon_approval] Data Type: string Dimension: Upon reject (Incident) Role: Discrete Dimension Remote Column: [Incident].[upon_reject] Data Type: string Dimension: User input (Incident) Role: Discrete Dimension Remote Column: [Incident].[user_input] Data Type: string Dimension: Watch list (Incident) Role: Discrete Dimension Remote Column: [Incident].[watch_list] Data Type: string Dimension: Work end (Incident) Role: Discrete Dimension Remote Column: [Incident].[work_end] Data Type: datetime Dimension: Work notes (Incident) Role: Discrete Dimension Remote Column: [Incident].[work_notes] Data Type: string Dimension: Work notes list (Incident) Role: Discrete Dimension Remote Column: [Incident].[work_notes_list] Data Type: string Dimension: Work start (Incident) Role: Discrete Dimension Remote Column: [Incident].[work_start] Data Type: datetime Problem Dimension: Active Role: Discrete Dimension Remote Column: [Problem].[active] Data Type: boolean Dimension: Activity due Role: Discrete Dimension Remote Column: [Problem].[activity_due] Data Type: datetime Dimension: Additional assignee list Role: Discrete Dimension Remote Column: [Problem].[additional_assignee_list] Data Type: string Dimension: Approval Role: Discrete Dimension Remote Column: [Problem].[approval] Data Type: string Dimension: Approval history Role: Discrete Dimension Remote Column: [Problem].[approval_history] Data Type: string Dimension: Approval set Role: Discrete Dimension Remote Column: [Problem].[approval_set] Data Type: datetime Dimension: Assigned to Role: Discrete Dimension Remote Column: [Problem].[assigned_to] Data Type: string Dimension: Assignment group Role: Discrete Dimension Remote Column: [Problem].[assignment_group] Data Type: string Dimension: Business duration Role: Discrete Dimension Remote Column: [Problem].[business_duration] Data Type: datetime Dimension: Business service Role: Discrete Dimension Remote Column: [Problem].[business_service] Data Type: string Dimension: Duration Role: Discrete Dimension Remote Column: [Problem].[calendar_duration] Data Type: datetime Dimension: Close notes Role: Discrete Dimension Remote Column: [Problem].[close_notes] Data Type: string Dimension: Closed Role: Discrete Dimension Remote Column: [Problem].[closed_at] Data Type: datetime Dimension: Closed by Role: Discrete Dimension Remote Column: [Problem].[closed_by] Data Type: string Dimension: Configuration item Role: Discrete Dimension Remote Column: [Problem].[cmdb_ci] Data Type: string Dimension: Additional comments Role: Discrete Dimension Remote Column: [Problem].[comments] Data Type: string Dimension: Comments and Work notes Role: Discrete Dimension Remote Column: [Problem].[comments_and_work_notes] Data Type: string Dimension: Company Role: Discrete Dimension Remote Column: [Problem].[company] Data Type: string Dimension: Contact type Role: Discrete Dimension Remote Column: [Problem].[contact_type] Data Type: string Dimension: Correlation display Role: Discrete Dimension Remote Column: [Problem].[correlation_display] Data Type: string Dimension: Correlation ID Role: Discrete Dimension Remote Column: [Problem].[correlation_id] Data Type: string Dimension: Delivery plan Role: Discrete Dimension Remote Column: [Problem].[delivery_plan] Data Type: string Dimension: Delivery task Role: Discrete Dimension Remote Column: [Problem].[delivery_task] Data Type: string Dimension: Description Role: Discrete Dimension Remote Column: [Problem].[description] Data Type: string Dimension: Due date Role: Discrete Dimension Remote Column: [Problem].[due_date] Data Type: datetime Dimension: Escalation Role: Discrete Dimension Remote Column: [Problem].[escalation] Data Type: integer Aggregation: Sum Dimension: Expected start Role: Discrete Dimension Remote Column: [Problem].[expected_start] Data Type: datetime Dimension: Follow up Role: Discrete Dimension Remote Column: [Problem].[follow_up] Data Type: datetime Dimension: Group list Role: Discrete Dimension Remote Column: [Problem].[group_list] Data Type: string Dimension: Knowledge Role: Discrete Dimension Remote Column: [Problem].[knowledge] Data Type: boolean Dimension: Known error Role: Discrete Dimension Remote Column: [Problem].[known_error] Data Type: boolean Dimension: Location Role: Discrete Dimension Remote Column: [Problem].[location] Data Type: string Dimension: Made SLA Role: Discrete Dimension Remote Column: [Problem].[made_sla] Data Type: boolean Dimension: Number Role: Discrete Dimension Remote Column: [Problem].[number] Data Type: string Dimension: Opened Role: Discrete Dimension Remote Column: [Problem].[opened_at] Data Type: datetime Dimension: Opened by Role: Discrete Dimension Remote Column: [Problem].[opened_by] Data Type: string Dimension: Parent Role: Discrete Dimension Remote Column: [Problem].[parent] Data Type: string Dimension: Priority Role: Discrete Dimension Remote Column: [Problem].[priority] Data Type: integer Aggregation: Sum Dimension: Problem state Role: Discrete Dimension Remote Column: [Problem].[problem_state] Data Type: integer Aggregation: Sum Dimension: Change request Role: Discrete Dimension Remote Column: [Problem].[rfc] Data Type: string Dimension: Short description Role: Discrete Dimension Remote Column: [Problem].[short_description] Data Type: string Dimension: SLA due Role: Discrete Dimension Remote Column: [Problem].[sla_due] Data Type: datetime Dimension: Task type Role: Discrete Dimension Remote Column: [Problem].[sys_class_name] Data Type: string Dimension: Created by Role: Discrete Dimension Remote Column: [Problem].[sys_created_by] Data Type: string Dimension: Created Role: Discrete Dimension Remote Column: [Problem].[sys_created_on] Data Type: datetime Dimension: Domain Role: Discrete Dimension Remote Column: [Problem].[sys_domain] Data Type: string Dimension: Domain Path Role: Discrete Dimension Remote Column: [Problem].[sys_domain_path] Data Type: string Dimension: Sys ID Role: Discrete Dimension Remote Column: [Problem].[sys_id] Data Type: string Dimension: Updated by Role: Discrete Dimension Remote Column: [Problem].[sys_updated_by] Data Type: string Dimension: Updated Role: Discrete Dimension Remote Column: [Problem].[sys_updated_on] Data Type: datetime Dimension: Time worked Role: Discrete Dimension Remote Column: [Problem].[time_worked] Data Type: string Dimension: Upon approval Role: Discrete Dimension Remote Column: [Problem].[upon_approval] Data Type: string Dimension: Upon reject Role: Discrete Dimension Remote Column: [Problem].[upon_reject] Data Type: string Dimension: User input Role: Discrete Dimension Remote Column: [Problem].[user_input] Data Type: string Dimension: Watch list Role: Discrete Dimension Remote Column: [Problem].[watch_list] Data Type: string Dimension: Workaround Role: Discrete Dimension Remote Column: [Problem].[work_around] Data Type: string Dimension: Work end Role: Discrete Dimension Remote Column: [Problem].[work_end] Data Type: datetime Dimension: Work notes Role: Discrete Dimension Remote Column: [Problem].[work_notes] Data Type: string Dimension: Work notes list Role: Discrete Dimension Remote Column: [Problem].[work_notes_list] Data Type: string Dimension: Work start Role: Discrete Dimension Remote Column: [Problem].[work_start] Data Type: datetime Calculated/Other Dimension: Measure Names Role: Discrete Dimension Data Type: string Measure Group Measure: Updates (Group) Role: Continous Measure Remote Column: [Group].[sys_mod_count] Data Type: integer Incident Measure: Business resolve time Role: Continous Measure Remote Column: [Incident].[business_stc] Data Type: integer Measure: Resolve time Role: Continous Measure Remote Column: [Incident].[calendar_stc] Data Type: integer Measure: Child Incidents Role: Continous Measure Remote Column: [Incident].[child_incidents] Data Type: integer Measure: Escalation (Incident) Role: Continous Measure Remote Column: [Incident].[escalation] Data Type: integer Measure: Impact (Incident) Role: Continous Measure Remote Column: [Incident].[impact] Data Type: integer Measure: Incident state Role: Continous Measure Remote Column: [Incident].[incident_state] Data Type: integer Measure: Notify Role: Continous Measure Remote Column: [Incident].[notify] Data Type: integer Measure: Order (Incident) Role: Continous Measure Remote Column: [Incident].[order] Data Type: integer Measure: Priority (Incident) Role: Continous Measure Remote Column: [Incident].[priority] Data Type: integer Measure: Reassignment count (Incident) Role: Continous Measure Remote Column: [Incident].[reassignment_count] Data Type: integer Measure: Reopen count Role: Continous Measure Remote Column: [Incident].[reopen_count] Data Type: integer Measure: Severity Role: Continous Measure Remote Column: [Incident].[severity] Data Type: integer Measure: State (Incident) Role: Continous Measure Remote Column: [Incident].[state] Data Type: integer Measure: Updates (Incident) Role: Continous Measure Remote Column: [Incident].[sys_mod_count] Data Type: integer Measure: Urgency (Incident) Role: Continous Measure Remote Column: [Incident].[urgency] Data Type: integer Problem Measure: Impact Role: Continous Measure Remote Column: [Problem].[impact] Data Type: integer Measure: Order Role: Continous Measure Remote Column: [Problem].[order] Data Type: integer Measure: Reassignment count Role: Continous Measure Remote Column: [Problem].[reassignment_count] Data Type: integer Measure: Related Incidents Role: Continous Measure Remote Column: [Problem].[related_incidents] Data Type: integer Measure: State Role: Continous Measure Remote Column: [Problem].[state] Data Type: integer Measure: Updates Role: Continous Measure Remote Column: [Problem].[sys_mod_count] Data Type: integer Measure: Urgency Role: Continous Measure Remote Column: [Problem].[urgency] Data Type: integer Calculated/Other Measure: Average Age (DD:HH:MM:SS) Role: Discrete Measure Data Type: string Formula: // This is a calculated field // It transforms time in seconds into DD:HH:MM:SS format STR(INT(AVG([Problem Age (seconds)])/86400)) + " day(s) " + IF (INT(AVG([Problem Age (seconds)])%86400/3600)) < 10 THEN "0" ELSE "" END + STR(INT(AVG([Problem Age (seconds)])%86400/3600)) + ":" + IF INT(AVG([Problem Age (seconds)])%3600/60) < 10 THEN "0" ELSE "" END + STR(INT(AVG([Problem Age (seconds)])%3600/60)) + ":" + IF INT(AVG([Problem Age (seconds)]) %3600 %60) < 10 THEN "0" ELSE "" END + STR(INT(AVG([Problem Age (seconds)]) %3600 %60)) Measure: Time to Close (Seconds) Role: Continous Measure Data Type: integer Formula: // This is a calculated field // It returns the time in seconds between opening and closening a problem DATEDIFF('second', [opened_at], [closed_at]) Measure: Average Time to Close (DD:HH:MM:SS) Role: Discrete Measure Data Type: string Formula: // This is a calculated field // It transforms time in seconds in DD:HH:MM:SS format STR(INT(AVG([Time to Close (Seconds)])/86400)) + " day(s) " + IF (INT(AVG([Time to Close (Seconds)])%86400/3600)) < 10 THEN "0" ELSE "" END + STR(INT(AVG([Time to Close (Seconds)])%86400/3600)) + ":" + IF INT(AVG([Time to Close (Seconds)])%3600/60) < 10 THEN "0" ELSE "" END + STR(INT(AVG([Time to Close (Seconds)])%3600/60)) + ":" + IF INT(AVG([Time to Close (Seconds)]) %3600 %60) < 10 THEN "0" ELSE "" END + STR(INT(AVG([Time to Close (Seconds)]) %3600 %60)) Measure: Known Errors Role: Continous Measure Data Type: real Formula: // This is a calculated field // It shows how much known errors represent from total of incidents COUNTD(IF [known_error] = TRUE THEN [number] END) / COUNT([number]) Measure: Problem Age (seconds) Role: Continous Measure Data Type: integer Formula: // This is a calculated field // It returns the difference in seconds between opening a problem and now { FIXED [number]: DATEDIFF("second", max([opened_at]), NOW())} Measure: With Related Incidents Role: Continous Measure Data Type: real Formula: // This is a calculated field // It counts each problem which one or more related incidents COUNTD(IF [related_incidents] != 0 THEN [number] END)/ COUNTD([number]) Measure: Opened Total Role: Continous Measure Data Type: integer Formula: // This is a calculated field // It counts each distinct incident opened COUNTD([number]) Measure: Still Active Role: Continous Measure Data Type: real Formula: // This is a calculated field // It counts each distinct problem which is still active COUNTD(IF [active]=TRUE THEN [number] END)/ COUNTD([number]) Measure: Incidents Attached Role: Continous Measure Data Type: integer Formula: // This is a calculated field // It counts each distict incident attached COUNTD([number (Incident)]) Measure: Measure Values Role: Continous Measure Data Type: real Measure: Not Worked Last 30 Days Role: Discrete Measure Data Type: real Formula: // This is a calculated field // It counts each distinct incident which hasn't been updated in the last 30 days IFNULL(COUNTD(IF DATEDIFF('day', { FIXED [number]: MAX([sys_updated_on])}, NOW())>=30 THEN [number] END),0) / COUNTD([number]) Measure: Number of Records Role: Continous Measure Data Type: integer Formula: 1 Semantic Values [Country].[Name]: "Reino Unido" Dashboards Dashboard: Problem Report Worksheets Worksheet: Active Problems Datasources: dev10906 Used Dimensions & Measures: [Active] [Average Time to Close (DD:HH:MM:SS)] [Closed] [Incidents Attached] [Known error] [Known Errors] [Name] [Not Worked Last 30 Days] [Number (Incident)] [Number] [Opened Total] [Opened] [Priority] [Related Incidents] [Still Active] [Time to Close (Seconds)] [Updated] [With Related Incidents] Used Remote Columns: [Group].[name] [Incident].[number] [Problem].[active] [Problem].[closed_at] [Problem].[known_error] [Problem].[number] [Problem].[opened_at] [Problem].[priority] [Problem].[related_incidents] [Problem].[sys_updated_on] Worksheet: Opened Problems Datasources: dev10906 Used Dimensions & Measures: [Active] [Name] [Number] [Opened] [Priority] Used Remote Columns: [Group].[name] [Problem].[active] [Problem].[number] [Problem].[opened_at] [Problem].[priority] Worksheet: Assignment Group Datasources: dev10906 Used Dimensions & Measures: [Active] [Name] [Number] [Opened (Incident)] [Opened] [Priority] Used Remote Columns: [Group].[name] [Incident].[opened_at] [Problem].[active] [Problem].[number] [Problem].[opened_at] [Problem].[priority] Worksheet: Problems Distribution by Average Age and Category Datasources: dev10906 Used Dimensions & Measures: [Active] [Average Age (DD:HH:MM:SS)] [Incidents Attached] [Name] [Number (Incident)] [Number] [Opened (Incident)] [Opened] [Priority] [Problem Age (seconds)] Used Remote Columns: [Group].[name] [Incident].[number] [Incident].[opened_at] [Problem].[active] [Problem].[number] [Problem].[opened_at] [Problem].[priority] Worksheet: Problems Datasources: dev10906 Used Dimensions & Measures: ["Attached Incidents"] [Active] [Description] [Incidents Attached] [Name] [Number (Incident)] [Number] [Opened] [Priority] [Short description] Used Remote Columns: [Group].[name] [Incident].[number] [Problem].[active] [Problem].[description] [Problem].[number] [Problem].[opened_at] [Problem].[priority] [Problem].[short_description] Dashboard Objects: Filter: [dev10906].[MY(opened_at)] Filter: [dev10906].[active] Text: Problem Report Worksheets Worksheet: Active Problems Visible: No Used Datasources Datasource: dev10906 Discrete Dimension: Active Remote Column: [Problem].[active] Discrete Dimension: Closed Remote Column: [Problem].[closed_at] Discrete Dimension: Known error Remote Column: [Problem].[known_error] Discrete Dimension: Name Remote Column: [Group].[name] Discrete Dimension: Number (Incident) Remote Column: [Incident].[number] Discrete Dimension: Number Remote Column: [Problem].[number] Discrete Dimension: Opened Remote Column: [Problem].[opened_at] Discrete Dimension: Priority Remote Column: [Problem].[priority] Discrete Dimension: Updated Remote Column: [Problem].[sys_updated_on] Continous Measure: Time to Close (Seconds) Discrete Measure: Average Time to Close (DD:HH:MM:SS) Continous Measure: Known Errors Continous Measure: With Related Incidents Continous Measure: Opened Total Continous Measure: Still Active Continous Measure: Incidents Attached Discrete Measure: Not Worked Last 30 Days Continous Measure: Related Incidents Remote Column: [Problem].[related_incidents] Marks Mark: All Type: Automatic Label: <[dev10906].[Multiple Values]> View Rows: [dev10906].[Average Time to Close (DD:HH:MM:SS)] Columns: [dev10906].[Measure Names()] Filters: [dev10906].[Measure Names()] [dev10906].[Action (Active,Name)] [dev10906].[Action (Priority)] [dev10906].[MY(opened_at)] [dev10906].[active] Manual Sorting: [dev10906].[Measure Names()] ASC Slices: [dev10906].[active] [dev10906].[Measure Names()] [dev10906].[MY(opened_at)] [dev10906].[Action (Priority)] [dev10906].[Action (Active,Name)] Styles Style: header [dev10906].[Average Time to Close (DD:HH:MM:SS)] width: 402 [dev10906].[Measure Names()] background-color: #f2f2f3 Style: field-labels Other background-color: #f2f2f3 Style: label [dev10906].[Measure Names()] font-weight: normal text-align: center vertical-align: center font-family: Tableau Regular [dev10906].[Average Time to Close (DD:HH:MM:SS)] text-align: center vertical-align: center font-family: Tableau Regular font-size: 14 Style: table Other background-color: #00000000 Style: table-div rows stroke-size: 3 line-pattern-only: solid line-visibility: off cols line-visibility: on line-pattern-only: solid stroke-color: #ffffff div-level: 1 stroke-size: 5 Style: title Other background-color: #f2f2f3 Style: quick-filter [dev10906].[MY(opened_at)] title: Opened Other font-family: Tableau Light background-color: #ffffff Style: quick-filter-title Other font-family: Tableau Light font-size: 8 Worksheet: Assignment Group Visible: No Used Datasources Datasource: dev10906 Discrete Dimension: Active Remote Column: [Problem].[active] Discrete Dimension: Name Remote Column: [Group].[name] Discrete Dimension: Number Remote Column: [Problem].[number] Discrete Dimension: Opened (Incident) Remote Column: [Incident].[opened_at] Discrete Dimension: Opened Remote Column: [Problem].[opened_at] Discrete Dimension: Priority Remote Column: [Problem].[priority] Marks Mark: All Type: Automatic Tooltip: <[dev10906].[name]> <[dev10906].[number]> opened incidents <[dev10906].[number]> of total View Rows: [dev10906].[name] Columns: [dev10906].[number] Filters: [dev10906].[Action (Active,DAY(Opened))] [dev10906].[Action (Priority)] [dev10906].[MY(opened_at (Incident))] [dev10906].[MY(opened_at)] [dev10906].[active] Slices: [dev10906].[MY(opened_at (Incident))] [dev10906].[active] [dev10906].[MY(opened_at)] [dev10906].[Action (Priority)] [dev10906].[Action (Active,DAY(Opened))] Styles Style: axis [dev10906].[number] auto-subtitle: true cols stroke-size: 1 line-visibility: off Other line-visibility: on line-pattern-only: solid stroke-color: #e6e6e6 rows line-visibility: on line-pattern-only: solid Style: cell [dev10906].[number] text-format: p0.0% Style: header Other height-header: 10 cols border-style: none Style: pane cols border-style: none Style: worksheet rows display-field-labels: false Style: refline refline0 stroke-size: 2 line-visibility: on line-pattern-only: dotted stroke-color: #ff862f fill-above: #00000000 fill-below: #00000000 text-format: n#,##0.0;-#,##0.0 font-family: Tableau Bold font-size: 8 color: #ff862f Style: gridline Other line-visibility: on line-pattern-only: solid stroke-size: 2 rows line-visibility: off Style: table-div rows line-visibility: off cols line-visibility: off Style: title Other background-color: #f2f2f3 Worksheet: Opened Problems Visible: No Used Datasources Datasource: dev10906 Discrete Dimension: Active Remote Column: [Problem].[active] Discrete Dimension: Name Remote Column: [Group].[name] Discrete Dimension: Number Remote Column: [Problem].[number] Discrete Dimension: Opened Remote Column: [Problem].[opened_at] Discrete Dimension: Priority Remote Column: [Problem].[priority] Marks Mark: All Type: Bar Tooltip: <[dev10906].[DAY(opened_at)]> <[dev10906].[number]> incidents View Rows: [dev10906].[number] Columns: [dev10906].[DAY(opened_at)] Filters: [dev10906].[Action (Active,Name)] [dev10906].[Action (Priority)] [dev10906].[MY(opened_at)] [dev10906].[active] Slices: [dev10906].[active] [dev10906].[MY(opened_at)] [dev10906].[Action (Active,Name)] [dev10906].[Action (Priority)] Styles Style: axis [dev10906].[number] display: false [dev10906].[DAY(opened_at)] auto-subtitle: true Other line-visibility: on line-pattern-only: solid stroke-color: #d4d4d4 rows line-visibility: off Style: header Other border-style: none Style: pane Other border-style: none Style: table Other background-color: #ffffff Style: worksheet cols display-field-labels: false Style: refline refline0 fill-above: #00000000 fill-below: #00000000 stroke-size: 1 line-visibility: on line-pattern-only: dashed Style: gridline Other stroke-size: 5 line-pattern-only: solid line-visibility: off Style: table-div rows line-visibility: off cols line-visibility: off Style: title Other background-color: #f2f2f3 Worksheet: Problems Visible: No Used Datasources Datasource: dev10906 Discrete Dimension: "Attached Incidents" Discrete Dimension: Active Remote Column: [Problem].[active] Discrete Dimension: Description Remote Column: [Problem].[description] Discrete Dimension: Name Remote Column: [Group].[name] Discrete Dimension: Number (Incident) Remote Column: [Incident].[number] Discrete Dimension: Number Remote Column: [Problem].[number] Discrete Dimension: Opened Remote Column: [Problem].[opened_at] Discrete Dimension: Priority Remote Column: [Problem].[priority] Discrete Dimension: Short description Remote Column: [Problem].[short_description] Continous Measure: Incidents Attached Marks Mark: All Type: Square Tooltip: <[dev10906].[number]> Opened since: <[dev10906].[ATTR(opened_at)]> Description: <[dev10906].[description]> Related Incidents: View Rows: [dev10906].[number] [dev10906].[short_description] Columns: [dev10906].["Attached Incidents"] Filters: [dev10906].[Action (Active,DAY(Opened))] [dev10906].[Action (Active,Name)] [dev10906].[Action (Priority)] [dev10906].[MY(opened_at)] [dev10906].[active] Slices: [dev10906].[MY(opened_at)] [dev10906].[active] [dev10906].[Action (Active,Name)] [dev10906].[Action (Priority)] [dev10906].[Action (Active,DAY(Opened))] Styles Style: cell Other width: 273 [dev10906].[short_description] height: 29 [dev10906].[number] height: 29 Style: header [dev10906].[description] width: 1004 [dev10906].[short_description] width: 132 background-color: #ffffff [dev10906].[number] width: 107 Other height-header: 36 [dev10906].[Incidents Attached] width: 168 rows band-color: #00000000 [dev10906].["Attached Incidents"] background-color: #ffffff Style: field-labels Other background-color: #00000000 font-family: Tableau Bold Style: label [dev10906].[number] font-family: Tableau Book font-size: 8 font-weight: normal color: #333333 [dev10906].[short_description] font-size: 8 [dev10906].[Incidents Attached] text-align: center [dev10906].["Attached Incidents"] font-family: Tableau Bold Style: pane rows band-color: #00000000 Style: table rows band-size: 1 Other background-color: #00000000 Style: worksheet cols display-field-labels: false Other font-size: 8 Style: table-div rows div-level: 3 line-visibility: on line-pattern-only: solid stroke-size: 1 stroke-color: #f5f5f5 cols stroke-size: 3 line-visibility: on line-pattern-only: solid stroke-color: #ffffff div-level: 1 Style: title Other background-color: #f2f2f3 Worksheet: Problems Distribution by Average Age and Category Visible: No Used Datasources Datasource: dev10906 Discrete Dimension: Active Remote Column: [Problem].[active] Discrete Dimension: Name Remote Column: [Group].[name] Discrete Dimension: Number (Incident) Remote Column: [Incident].[number] Discrete Dimension: Number Remote Column: [Problem].[number] Discrete Dimension: Opened (Incident) Remote Column: [Incident].[opened_at] Discrete Dimension: Opened Remote Column: [Problem].[opened_at] Discrete Dimension: Priority Remote Column: [Problem].[priority] Discrete Measure: Average Age (DD:HH:MM:SS) Continous Measure: Problem Age (seconds) Continous Measure: Incidents Attached Marks Mark: All Type: Circle Label: <[dev10906].[Calculation_1103944901415100421]> <[dev10906].[Average Time to Close (DD:HH:MM:SS) (copy)]> Tooltip: Problem <[dev10906].[number]> Priority: <[dev10906].[priority]> Age: <[dev10906].[Average Time to Close (DD:HH:MM:SS) (copy)]> Opened At: <[dev10906].[ATTR(opened_at)]> Number of Related Incidents: <[dev10906].[Incidents Attached]> View Rows: [dev10906].[priority] Columns: [dev10906].[AVG(Problem Age (seconds))] Filters: [dev10906].[Action (Active,DAY(Opened))] [dev10906].[Action (Active,Name)] [dev10906].[MY(opened_at (Incident))] [dev10906].[MY(opened_at)] [dev10906].[active] Slices: [dev10906].[MY(opened_at (Incident))] [dev10906].[active] [dev10906].[MY(opened_at)] [dev10906].[Action (Active,Name)] [dev10906].[Action (Active,DAY(Opened))] Styles Style: axis [dev10906].[AVG(Problem Age (seconds))] auto-subtitle: true display: false Other render-fold-reversed: true stroke-size: 5 line-visibility: on line-pattern-only: solid rows line-visibility: on line-pattern-only: solid stroke-size: 3 cols line-visibility: off Style: header [dev10906].[priority] width: 131 Other border-style: none Style: label [dev10906].[priority] display: true text-align: center vertical-align: center font-size: 8 Style: pane Other border-style: none Style: table Other show-null-value-warning: false Style: worksheet rows display-field-labels: false Style: refline refline0 fill-above: #00000000 font-family: Tableau Bold color: #ff4346 background-color: #ffffff00 font-size: 8 vertical-align: bottom text-align: right line-visibility: on line-pattern-only: solid stroke-color: #f5f5f5 fill-below: #d4d4d4 stroke-size: 2 Style: gridline Other stroke-size: 5 line-pattern-only: solid line-visibility: off Style: zeroline Other stroke-size: 5 line-pattern-only: solid line-visibility: off Style: table-div rows div-level: 1 stroke-color: #f5f5f5 line-visibility: on line-pattern-only: solid stroke-size: 2 cols line-pattern-only: solid line-visibility: off div-level: 0 Style: title Other background-color: #f2f2f3 Worksheet: Sheet 1 Visible: No Marks Mark: All Type: Automatic View Worksheet: Tooltip - List of Incidents Visible: No Used Datasources Datasource: dev10906 Discrete Dimension: Description Remote Column: [Problem].[description] Discrete Dimension: Number (Incident) Remote Column: [Incident].[number] Discrete Dimension: Number Remote Column: [Problem].[number] Discrete Dimension: Short description (Incident) Remote Column: [Incident].[short_description] Discrete Dimension: Short description Remote Column: [Problem].[short_description] Marks Mark: All Type: Automatic View Rows: [dev10906].[number (Incident)] Filters: [dev10906].[Tooltip (Description,Number,Short description)] Slices: [dev10906].[Tooltip (Description,Number,Short description)] Styles Style: cell [dev10906].[number (Incident)] height: 24 Style: header [dev10906].[number (Incident)] width: 116 rows band-color: #00000000 Style: label [dev10906].[number (Incident)] font-family: Tableau Book color: #31a1b3 Style: pane rows band-color: #00000000 Style: table rows band-size: 1 Style: worksheet rows display-field-labels: false Style: table-div rows div-level: 1 stroke-color: #f5f5f5