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:
<Sheet name="Tooltip - List of Incidents" maxwidth="300" maxheight="1000" filter="<All Fields>">
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