Workbook Information
Author: Unknown
Embedded Datasources
Datasource: Parameters
Connection
Measure
Calculated/Other
Measure: Instance Name
Role: Discrete Measure
Data Type: string
Formula: ""
Default Value: ""
Parameter Type: any
Datasource: Incidents
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: as-is
Tables
Table: Incident
Database Object: [incident]
Connection: dev10906
Table: AssignedTo
Database Object: [sys_user]
Connection: dev10906
Table: ClosedBy
Database Object: [sys_user]
Connection: dev10906
Table: OpenedBy
Database Object: [sys_user]
Connection: dev10906
Table: Configuration Item
Database Object: [cmdb_ci]
Connection: dev10906
Table: Group
Database Object: [sys_user_group]
Connection: dev10906
Dimension
AssignedTo
Dimension: Accumulated roles
Role: Discrete Dimension
Remote Column: [AssignedTo].[accumulated_roles]
Data Type: string
Dimension: Active (AssignedTo)
Role: Discrete Dimension
Remote Column: [AssignedTo].[active]
Data Type: boolean
Dimension: Building
Role: Discrete Dimension
Remote Column: [AssignedTo].[building]
Data Type: string
Dimension: City
Role: Discrete Dimension
Remote Column: [AssignedTo].[city]
Data Type: string
Dimension: Company (User)
Role: Discrete Dimension
Remote Column: [AssignedTo].[company]
Data Type: string
Dimension: Cost center
Role: Discrete Dimension
Remote Column: [AssignedTo].[cost_center]
Data Type: string
Dimension: Country code
Role: Discrete Dimension
Remote Column: [AssignedTo].[country]
Data Type: string
Dimension: Date format
Role: Discrete Dimension
Remote Column: [AssignedTo].[date_format]
Data Type: string
Dimension: Default perspective
Role: Discrete Dimension
Remote Column: [AssignedTo].[default_perspective]
Data Type: string
Dimension: Department
Role: Discrete Dimension
Remote Column: [AssignedTo].[department]
Data Type: string
Dimension: Email
Role: Discrete Dimension
Remote Column: [AssignedTo].[email]
Data Type: string
Dimension: Employee number
Role: Discrete Dimension
Remote Column: [AssignedTo].[employee_number]
Data Type: string
Dimension: First name
Role: Discrete Dimension
Remote Column: [AssignedTo].[first_name]
Data Type: string
Dimension: Gender
Role: Discrete Dimension
Remote Column: [AssignedTo].[gender]
Data Type: string
Dimension: Home phone
Role: Discrete Dimension
Remote Column: [AssignedTo].[home_phone]
Data Type: string
Dimension: Internal Integration User
Role: Discrete Dimension
Remote Column: [AssignedTo].[internal_integration_user]
Data Type: boolean
Dimension: Prefix
Role: Discrete Dimension
Remote Column: [AssignedTo].[introduction]
Data Type: string
Dimension: Last login
Role: Discrete Dimension
Remote Column: [AssignedTo].[last_login]
Data Type: date
Dimension: Last login time
Role: Discrete Dimension
Remote Column: [AssignedTo].[last_login_time]
Data Type: datetime
Dimension: Last name
Role: Discrete Dimension
Remote Column: [AssignedTo].[last_name]
Data Type: string
Dimension: LDAP server
Role: Discrete Dimension
Remote Column: [AssignedTo].[ldap_server]
Data Type: string
Dimension: Location (User)
Role: Discrete Dimension
Remote Column: [AssignedTo].[location]
Data Type: string
Dimension: Locked out
Role: Discrete Dimension
Remote Column: [AssignedTo].[locked_out]
Data Type: boolean
Dimension: Manager
Role: Discrete Dimension
Remote Column: [AssignedTo].[manager]
Data Type: string
Dimension: Middle name
Role: Discrete Dimension
Remote Column: [AssignedTo].[middle_name]
Data Type: string
Dimension: Mobile phone
Role: Discrete Dimension
Remote Column: [AssignedTo].[mobile_phone]
Data Type: string
Dimension: Name
Role: Discrete Dimension
Remote Column: [AssignedTo].[name]
Data Type: string
Dimension: Password needs reset
Role: Discrete Dimension
Remote Column: [AssignedTo].[password_needs_reset]
Data Type: boolean
Dimension: Business phone
Role: Discrete Dimension
Remote Column: [AssignedTo].[phone]
Data Type: string
Dimension: Photo
Role: Discrete Dimension
Remote Column: [AssignedTo].[photo]
Data Type: string
Dimension: Language
Role: Discrete Dimension
Remote Column: [AssignedTo].[preferred_language]
Data Type: string
Dimension: Roles
Role: Discrete Dimension
Remote Column: [AssignedTo].[roles]
Data Type: string
Dimension: Schedule
Role: Discrete Dimension
Remote Column: [AssignedTo].[schedule]
Data Type: string
Dimension: Source
Role: Discrete Dimension
Remote Column: [AssignedTo].[source]
Data Type: string
Dimension: State / Province
Role: Discrete Dimension
Remote Column: [AssignedTo].[state]
Data Type: string
Dimension: Street
Role: Discrete Dimension
Remote Column: [AssignedTo].[street]
Data Type: string
Dimension: Class
Role: Discrete Dimension
Remote Column: [AssignedTo].[sys_class_name]
Data Type: string
Dimension: Created by (AssignedTo)
Role: Discrete Dimension
Remote Column: [AssignedTo].[sys_created_by]
Data Type: string
Dimension: Created (AssignedTo)
Role: Discrete Dimension
Remote Column: [AssignedTo].[sys_created_on]
Data Type: datetime
Dimension: Domain (AssignedTo)
Role: Discrete Dimension
Remote Column: [AssignedTo].[sys_domain]
Data Type: string
Dimension: Domain Path (AssignedTo)
Role: Discrete Dimension
Remote Column: [AssignedTo].[sys_domain_path]
Data Type: string
Dimension: Sys ID (AssignedTo)
Role: Discrete Dimension
Remote Column: [AssignedTo].[sys_id]
Data Type: string
Dimension: Updated by (AssignedTo)
Role: Discrete Dimension
Remote Column: [AssignedTo].[sys_updated_by]
Data Type: string
Dimension: Updated (AssignedTo)
Role: Discrete Dimension
Remote Column: [AssignedTo].[sys_updated_on]
Data Type: datetime
Dimension: Time format
Role: Discrete Dimension
Remote Column: [AssignedTo].[time_format]
Data Type: string
Dimension: Time zone
Role: Discrete Dimension
Remote Column: [AssignedTo].[time_zone]
Data Type: string
Dimension: Title
Role: Discrete Dimension
Remote Column: [AssignedTo].[title]
Data Type: string
Dimension: u
Role: Discrete Dimension
Remote Column: [AssignedTo].[u_u]
Data Type: string
Dimension: User ID
Role: Discrete Dimension
Remote Column: [AssignedTo].[user_name]
Data Type: string
Dimension: Password
Role: Discrete Dimension
Remote Column: [AssignedTo].[user_password]
Data Type: string
Dimension: VIP
Role: Discrete Dimension
Remote Column: [AssignedTo].[vip]
Data Type: boolean
Dimension: Web service access only
Role: Discrete Dimension
Remote Column: [AssignedTo].[web_service_access_only]
Data Type: boolean
Dimension: Zip / Postal code
Role: Discrete Dimension
Remote Column: [AssignedTo].[zip]
Data Type: string
ClosedBy
Dimension: Accumulated roles (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[accumulated_roles]
Data Type: string
Dimension: Active (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[active]
Data Type: boolean
Dimension: Building (User)
Role: Discrete Dimension
Remote Column: [ClosedBy].[building]
Data Type: string
Dimension: City (User)
Role: Discrete Dimension
Remote Column: [ClosedBy].[city]
Data Type: string
Dimension: Company (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[company]
Data Type: string
Dimension: Cost center (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[cost_center]
Data Type: string
Dimension: Country code (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[country]
Data Type: string
Dimension: Date format (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[date_format]
Data Type: string
Dimension: Default perspective (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[default_perspective]
Data Type: string
Dimension: Department (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[department]
Data Type: string
Dimension: Email (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[email]
Data Type: string
Dimension: Employee number (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[employee_number]
Data Type: string
Dimension: First name (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[first_name]
Data Type: string
Dimension: Gender (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[gender]
Data Type: string
Dimension: Home phone (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[home_phone]
Data Type: string
Dimension: Internal Integration User (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[internal_integration_user]
Data Type: boolean
Dimension: Prefix (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[introduction]
Data Type: string
Dimension: Last login (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[last_login]
Data Type: date
Dimension: Last login time (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[last_login_time]
Data Type: datetime
Dimension: Last name (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[last_name]
Data Type: string
Dimension: LDAP server (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[ldap_server]
Data Type: string
Dimension: Location (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[location]
Data Type: string
Dimension: Locked out (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[locked_out]
Data Type: boolean
Dimension: Manager (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[manager]
Data Type: string
Dimension: Middle name (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[middle_name]
Data Type: string
Dimension: Mobile phone (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[mobile_phone]
Data Type: string
Dimension: Name (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[name]
Data Type: string
Dimension: Password needs reset (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[password_needs_reset]
Data Type: boolean
Dimension: Business phone (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[phone]
Data Type: string
Dimension: Photo (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[photo]
Data Type: string
Dimension: Language (User)
Role: Discrete Dimension
Remote Column: [ClosedBy].[preferred_language]
Data Type: string
Dimension: Roles (User)
Role: Discrete Dimension
Remote Column: [ClosedBy].[roles]
Data Type: string
Dimension: Schedule (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[schedule]
Data Type: string
Dimension: Source (User)
Role: Discrete Dimension
Remote Column: [ClosedBy].[source]
Data Type: string
Dimension: State / Province (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[state]
Data Type: string
Dimension: Street (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[street]
Data Type: string
Dimension: Class (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[sys_class_name]
Data Type: string
Dimension: Created by (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[sys_created_by]
Data Type: string
Dimension: Created (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[sys_created_on]
Data Type: datetime
Dimension: Domain (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[sys_domain]
Data Type: string
Dimension: Domain Path (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[sys_domain_path]
Data Type: string
Dimension: Sys ID (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[sys_id]
Data Type: string
Dimension: Updated by (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[sys_updated_by]
Data Type: string
Dimension: Updated (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[sys_updated_on]
Data Type: datetime
Dimension: Time format (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[time_format]
Data Type: string
Dimension: Time zone (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[time_zone]
Data Type: string
Dimension: Title (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[title]
Data Type: string
Dimension: u (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[u_u]
Data Type: string
Dimension: User ID (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[user_name]
Data Type: string
Dimension: Password (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[user_password]
Data Type: string
Dimension: VIP (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[vip]
Data Type: boolean
Dimension: Web service access only (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[web_service_access_only]
Data Type: boolean
Dimension: Zip / Postal code (ClosedBy)
Role: Discrete Dimension
Remote Column: [ClosedBy].[zip]
Data Type: string
Configuration Item
Dimension: Asset
Role: Discrete Dimension
Remote Column: [Configuration Item].[asset]
Data Type: string
Dimension: Asset tag
Role: Discrete Dimension
Remote Column: [Configuration Item].[asset_tag]
Data Type: string
Dimension: Assigned
Role: Discrete Dimension
Remote Column: [Configuration Item].[assigned]
Data Type: datetime
Dimension: Assigned to (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[assigned_to]
Data Type: string
Dimension: Assignment group (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[assignment_group]
Data Type: string
Dimension: Attributes
Role: Discrete Dimension
Remote Column: [Configuration Item].[attributes]
Data Type: string
Dimension: Can Print
Role: Discrete Dimension
Remote Column: [Configuration Item].[can_print]
Data Type: boolean
Dimension: Category (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[category]
Data Type: string
Dimension: Approval group
Role: Discrete Dimension
Remote Column: [Configuration Item].[change_control]
Data Type: string
Dimension: Checked in
Role: Discrete Dimension
Remote Column: [Configuration Item].[checked_in]
Data Type: datetime
Dimension: Checked out
Role: Discrete Dimension
Remote Column: [Configuration Item].[checked_out]
Data Type: datetime
Dimension: Comments
Role: Discrete Dimension
Remote Column: [Configuration Item].[comments]
Data Type: string
Dimension: Company (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[company]
Data Type: string
Dimension: Correlation ID (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[correlation_id]
Data Type: string
Dimension: Cost
Role: Discrete Dimension
Remote Column: [Configuration Item].[cost]
Data Type: string
Dimension: Cost currency
Role: Discrete Dimension
Remote Column: [Configuration Item].[cost_cc]
Data Type: string
Dimension: Cost center (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[cost_center]
Data Type: string
Dimension: Order received
Role: Discrete Dimension
Remote Column: [Configuration Item].[delivery_date]
Data Type: datetime
Dimension: Department (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[department]
Data Type: string
Dimension: Discovery source
Role: Discrete Dimension
Remote Column: [Configuration Item].[discovery_source]
Data Type: string
Dimension: DNS Domain
Role: Discrete Dimension
Remote Column: [Configuration Item].[dns_domain]
Data Type: string
Dimension: Due
Role: Discrete Dimension
Remote Column: [Configuration Item].[due]
Data Type: datetime
Dimension: Due in
Role: Discrete Dimension
Remote Column: [Configuration Item].[due_in]
Data Type: string
Dimension: First discovered
Role: Discrete Dimension
Remote Column: [Configuration Item].[first_discovered]
Data Type: datetime
Dimension: Fully qualified domain name
Role: Discrete Dimension
Remote Column: [Configuration Item].[fqdn]
Data Type: string
Dimension: GL account
Role: Discrete Dimension
Remote Column: [Configuration Item].[gl_account]
Data Type: string
Dimension: Installed
Role: Discrete Dimension
Remote Column: [Configuration Item].[install_date]
Data Type: datetime
Dimension: Status
Role: Discrete Dimension
Remote Column: [Configuration Item].[install_status]
Data Type: integer
Aggregation: Sum
Dimension: Invoice number
Role: Discrete Dimension
Remote Column: [Configuration Item].[invoice_number]
Data Type: string
Dimension: IP Address
Role: Discrete Dimension
Remote Column: [Configuration Item].[ip_address]
Data Type: string
Dimension: Justification
Role: Discrete Dimension
Remote Column: [Configuration Item].[justification]
Data Type: string
Dimension: Most recent discovery
Role: Discrete Dimension
Remote Column: [Configuration Item].[last_discovered]
Data Type: datetime
Dimension: Lease contract
Role: Discrete Dimension
Remote Column: [Configuration Item].[lease_id]
Data Type: string
Dimension: Location (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[location]
Data Type: string
Dimension: MAC Address
Role: Discrete Dimension
Remote Column: [Configuration Item].[mac_address]
Data Type: string
Dimension: Maintenance schedule
Role: Discrete Dimension
Remote Column: [Configuration Item].[maintenance_schedule]
Data Type: string
Dimension: Managed by
Role: Discrete Dimension
Remote Column: [Configuration Item].[managed_by]
Data Type: string
Dimension: Manufacturer
Role: Discrete Dimension
Remote Column: [Configuration Item].[manufacturer]
Data Type: string
Dimension: Model ID
Role: Discrete Dimension
Remote Column: [Configuration Item].[model_id]
Data Type: string
Dimension: Model number
Role: Discrete Dimension
Remote Column: [Configuration Item].[model_number]
Data Type: string
Dimension: Monitor
Role: Discrete Dimension
Remote Column: [Configuration Item].[monitor]
Data Type: boolean
Dimension: Name (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[name]
Data Type: string
Dimension: Ordered
Role: Discrete Dimension
Remote Column: [Configuration Item].[order_date]
Data Type: datetime
Dimension: Owned by
Role: Discrete Dimension
Remote Column: [Configuration Item].[owned_by]
Data Type: string
Dimension: PO number
Role: Discrete Dimension
Remote Column: [Configuration Item].[po_number]
Data Type: string
Dimension: Purchased
Role: Discrete Dimension
Remote Column: [Configuration Item].[purchase_date]
Data Type: date
Dimension: Schedule (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[schedule]
Data Type: string
Dimension: Serial number
Role: Discrete Dimension
Remote Column: [Configuration Item].[serial_number]
Data Type: string
Dimension: Description (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[short_description]
Data Type: string
Dimension: Skip sync
Role: Discrete Dimension
Remote Column: [Configuration Item].[skip_sync]
Data Type: boolean
Dimension: Start date
Role: Discrete Dimension
Remote Column: [Configuration Item].[start_date]
Data Type: datetime
Dimension: Subcategory (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[subcategory]
Data Type: string
Dimension: Support group
Role: Discrete Dimension
Remote Column: [Configuration Item].[support_group]
Data Type: string
Dimension: Supported by
Role: Discrete Dimension
Remote Column: [Configuration Item].[supported_by]
Data Type: string
Dimension: Class (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[sys_class_name]
Data Type: string
Dimension: Created by (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[sys_created_by]
Data Type: string
Dimension: Created (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[sys_created_on]
Data Type: datetime
Dimension: Domain (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[sys_domain]
Data Type: string
Dimension: Domain Path (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[sys_domain_path]
Data Type: string
Dimension: Sys ID (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[sys_id]
Data Type: string
Dimension: Updated by (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[sys_updated_by]
Data Type: string
Dimension: Updated (Configuration Item)
Role: Discrete Dimension
Remote Column: [Configuration Item].[sys_updated_on]
Data Type: datetime
Dimension: Requires verification
Role: Discrete Dimension
Remote Column: [Configuration Item].[unverified]
Data Type: boolean
Dimension: Vendor
Role: Discrete Dimension
Remote Column: [Configuration Item].[vendor]
Data Type: string
Dimension: Warranty expiration
Role: Discrete Dimension
Remote Column: [Configuration Item].[warranty_expiration]
Data Type: date
Group
Dimension: Active (Group)
Role: Discrete Dimension
Remote Column: [Group].[active]
Data Type: boolean
Dimension: Cost center (Group)
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 (Group)
Role: Discrete Dimension
Remote Column: [Group].[manager]
Data Type: string
Dimension: Name (Group)
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 (Group)
Role: Discrete Dimension
Remote Column: [Group].[roles]
Data Type: string
Dimension: Source (Group)
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 (Group)
Role: Discrete Dimension
Remote Column: [Group].[u_u]
Data Type: string
Incident
Dimension: Active
Role: Discrete Dimension
Remote Column: [Incident].[active]
Data Type: boolean
Dimension: Activity due
Role: Discrete Dimension
Remote Column: [Incident].[activity_due]
Data Type: datetime
Dimension: Additional assignee list
Role: Discrete Dimension
Remote Column: [Incident].[additional_assignee_list]
Data Type: string
Dimension: Approval
Role: Discrete Dimension
Remote Column: [Incident].[approval]
Data Type: string
Dimension: Approval history
Role: Discrete Dimension
Remote Column: [Incident].[approval_history]
Data Type: string
Dimension: Approval set
Role: Discrete Dimension
Remote Column: [Incident].[approval_set]
Data Type: datetime
Dimension: Assigned to
Role: Discrete Dimension
Remote Column: [Incident].[assigned_to]
Data Type: string
Dimension: Assignment group
Role: Discrete Dimension
Remote Column: [Incident].[assignment_group]
Data Type: string
Dimension: Business duration
Role: Discrete Dimension
Remote Column: [Incident].[business_duration]
Data Type: datetime
Dimension: Business service
Role: Discrete Dimension
Remote Column: [Incident].[business_service]
Data Type: string
Dimension: Duration
Role: Discrete Dimension
Remote Column: [Incident].[calendar_duration]
Data Type: datetime
Dimension: Resolve time
Role: Discrete Dimension
Remote Column: [Incident].[calendar_stc]
Data Type: integer
Aggregation: Sum
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: Child Incidents
Role: Discrete Dimension
Remote Column: [Incident].[child_incidents]
Data Type: integer
Aggregation: Sum
Dimension: Close code
Role: Discrete Dimension
Remote Column: [Incident].[close_code]
Data Type: string
Dimension: Close notes
Role: Discrete Dimension
Remote Column: [Incident].[close_notes]
Data Type: string
Dimension: Closed
Role: Discrete Dimension
Remote Column: [Incident].[closed_at]
Data Type: datetime
Dimension: Closed by
Role: Discrete Dimension
Remote Column: [Incident].[closed_by]
Data Type: string
Dimension: Configuration item
Role: Discrete Dimension
Remote Column: [Incident].[cmdb_ci]
Data Type: string
Dimension: Additional comments
Role: Discrete Dimension
Remote Column: [Incident].[comments]
Data Type: string
Dimension: Comments and Work notes
Role: Discrete Dimension
Remote Column: [Incident].[comments_and_work_notes]
Data Type: string
Dimension: Company
Role: Discrete Dimension
Remote Column: [Incident].[company]
Data Type: string
Dimension: Contact type
Role: Discrete Dimension
Remote Column: [Incident].[contact_type]
Data Type: string
Dimension: Correlation display
Role: Discrete Dimension
Remote Column: [Incident].[correlation_display]
Data Type: string
Dimension: Correlation ID
Role: Discrete Dimension
Remote Column: [Incident].[correlation_id]
Data Type: string
Dimension: Delivery plan
Role: Discrete Dimension
Remote Column: [Incident].[delivery_plan]
Data Type: string
Dimension: Delivery task
Role: Discrete Dimension
Remote Column: [Incident].[delivery_task]
Data Type: string
Dimension: Description
Role: Discrete Dimension
Remote Column: [Incident].[description]
Data Type: string
Dimension: Due date
Role: Discrete Dimension
Remote Column: [Incident].[due_date]
Data Type: datetime
Dimension: Escalation
Role: Discrete Dimension
Remote Column: [Incident].[escalation]
Data Type: integer
Aggregation: Sum
Dimension: Expected start
Role: Discrete Dimension
Remote Column: [Incident].[expected_start]
Data Type: datetime
Dimension: Follow up
Role: Discrete Dimension
Remote Column: [Incident].[follow_up]
Data Type: datetime
Dimension: Group list
Role: Discrete Dimension
Remote Column: [Incident].[group_list]
Data Type: string
Dimension: Impact
Role: Discrete Dimension
Remote Column: [Incident].[impact]
Data Type: integer
Aggregation: Sum
Dimension: Incident state
Role: Discrete Dimension
Remote Column: [Incident].[incident_state]
Data Type: string
Dimension: Knowledge
Role: Discrete Dimension
Remote Column: [Incident].[knowledge]
Data Type: boolean
Dimension: Location
Role: Discrete Dimension
Remote Column: [Incident].[location]
Data Type: string
Dimension: Made SLA
Role: Discrete Dimension
Remote Column: [Incident].[made_sla]
Data Type: boolean
Dimension: Notify
Role: Discrete Dimension
Remote Column: [Incident].[notify]
Data Type: integer
Aggregation: Sum
Dimension: Number
Role: Discrete Dimension
Remote Column: [Incident].[number]
Data Type: string
Dimension: Opened
Role: Discrete Dimension
Remote Column: [Incident].[opened_at]
Data Type: datetime
Dimension: Opened by
Role: Discrete Dimension
Remote Column: [Incident].[opened_by]
Data Type: string
Dimension: Order
Role: Discrete Dimension
Remote Column: [Incident].[order]
Data Type: integer
Aggregation: Sum
Dimension: Parent
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: Priority
Role: Discrete Dimension
Remote Column: [Incident].[priority]
Data Type: string
Dimension: Problem
Role: Discrete Dimension
Remote Column: [Incident].[problem_id]
Data Type: string
Dimension: Reassignment count
Role: Discrete Dimension
Remote Column: [Incident].[reassignment_count]
Data Type: integer
Aggregation: Sum
Dimension: Reopen count
Role: Discrete Dimension
Remote Column: [Incident].[reopen_count]
Data Type: integer
Aggregation: Sum
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: Severity
Role: Discrete Dimension
Remote Column: [Incident].[severity]
Data Type: integer
Aggregation: Sum
Dimension: Short description
Role: Discrete Dimension
Remote Column: [Incident].[short_description]
Data Type: string
Dimension: SLA due
Role: Discrete Dimension
Remote Column: [Incident].[sla_due]
Data Type: datetime
Dimension: State
Role: Discrete Dimension
Remote Column: [Incident].[state]
Data Type: string
Dimension: Subcategory
Role: Discrete Dimension
Remote Column: [Incident].[subcategory]
Data Type: string
Dimension: Task type
Role: Discrete Dimension
Remote Column: [Incident].[sys_class_name]
Data Type: string
Dimension: Created by
Role: Discrete Dimension
Remote Column: [Incident].[sys_created_by]
Data Type: string
Dimension: Created
Role: Discrete Dimension
Remote Column: [Incident].[sys_created_on]
Data Type: datetime
Dimension: Domain
Role: Discrete Dimension
Remote Column: [Incident].[sys_domain]
Data Type: string
Dimension: Domain Path
Role: Discrete Dimension
Remote Column: [Incident].[sys_domain_path]
Data Type: string
Dimension: Sys ID
Role: Discrete Dimension
Remote Column: [Incident].[sys_id]
Data Type: string
Dimension: Updates
Role: Discrete Dimension
Remote Column: [Incident].[sys_mod_count]
Data Type: integer
Aggregation: Sum
Dimension: Updated by
Role: Discrete Dimension
Remote Column: [Incident].[sys_updated_by]
Data Type: string
Dimension: Updated
Role: Discrete Dimension
Remote Column: [Incident].[sys_updated_on]
Data Type: datetime
Dimension: Time worked
Role: Discrete Dimension
Remote Column: [Incident].[time_worked]
Data Type: string
Dimension: Upon approval
Role: Discrete Dimension
Remote Column: [Incident].[upon_approval]
Data Type: string
Dimension: Upon reject
Role: Discrete Dimension
Remote Column: [Incident].[upon_reject]
Data Type: string
Dimension: Urgency
Role: Discrete Dimension
Remote Column: [Incident].[urgency]
Data Type: integer
Aggregation: Sum
Dimension: User input
Role: Discrete Dimension
Remote Column: [Incident].[user_input]
Data Type: string
Dimension: Watch list
Role: Discrete Dimension
Remote Column: [Incident].[watch_list]
Data Type: string
Dimension: Actual end
Role: Discrete Dimension
Remote Column: [Incident].[work_end]
Data Type: datetime
Dimension: Work notes
Role: Discrete Dimension
Remote Column: [Incident].[work_notes]
Data Type: string
Dimension: Work notes list
Role: Discrete Dimension
Remote Column: [Incident].[work_notes_list]
Data Type: string
Dimension: Actual start
Role: Discrete Dimension
Remote Column: [Incident].[work_start]
Data Type: datetime
OpenedBy
Dimension: Accumulated roles (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[accumulated_roles]
Data Type: string
Dimension: Active (User)
Role: Discrete Dimension
Remote Column: [OpenedBy].[active]
Data Type: boolean
Dimension: Building (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[building]
Data Type: string
Dimension: City (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[city]
Data Type: string
Dimension: Company (User)
Role: Discrete Dimension
Remote Column: [OpenedBy].[company]
Data Type: string
Dimension: Cost center (User)
Role: Discrete Dimension
Remote Column: [OpenedBy].[cost_center]
Data Type: string
Dimension: Country code (User)
Role: Discrete Dimension
Remote Column: [OpenedBy].[country]
Data Type: string
Dimension: Date format (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[date_format]
Data Type: string
Dimension: Default perspective (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[default_perspective]
Data Type: string
Dimension: Department (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[department]
Data Type: string
Dimension: Email (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[email]
Data Type: string
Dimension: Employee number (User)
Role: Discrete Dimension
Remote Column: [OpenedBy].[employee_number]
Data Type: string
Dimension: First name (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[first_name]
Data Type: string
Dimension: Gender (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[gender]
Data Type: string
Dimension: Home phone (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[home_phone]
Data Type: string
Dimension: Internal Integration User (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[internal_integration_user]
Data Type: boolean
Dimension: Prefix (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[introduction]
Data Type: string
Dimension: Last login (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[last_login]
Data Type: date
Dimension: Last login time (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[last_login_time]
Data Type: datetime
Dimension: Last name (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[last_name]
Data Type: string
Dimension: LDAP server (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[ldap_server]
Data Type: string
Dimension: Location (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[location]
Data Type: string
Dimension: Locked out (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[locked_out]
Data Type: boolean
Dimension: Manager (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[manager]
Data Type: string
Dimension: Middle name (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[middle_name]
Data Type: string
Dimension: Mobile phone (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[mobile_phone]
Data Type: string
Dimension: Name (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[name]
Data Type: string
Dimension: Password needs reset (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[password_needs_reset]
Data Type: boolean
Dimension: Business phone (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[phone]
Data Type: string
Dimension: Photo (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[photo]
Data Type: string
Dimension: Language (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[preferred_language]
Data Type: string
Dimension: Roles (User)
Role: Discrete Dimension
Remote Column: [OpenedBy].[roles]
Data Type: string
Dimension: Schedule (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[schedule]
Data Type: string
Dimension: Source (User)
Role: Discrete Dimension
Remote Column: [OpenedBy].[source]
Data Type: string
Dimension: State / Province (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[state]
Data Type: string
Dimension: Street (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[street]
Data Type: string
Dimension: Class (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[sys_class_name]
Data Type: string
Dimension: Created by (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[sys_created_by]
Data Type: string
Dimension: Created (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[sys_created_on]
Data Type: datetime
Dimension: Domain (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[sys_domain]
Data Type: string
Dimension: Domain Path (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[sys_domain_path]
Data Type: string
Dimension: Sys ID (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[sys_id]
Data Type: string
Dimension: Updated by (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[sys_updated_by]
Data Type: string
Dimension: Updated (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[sys_updated_on]
Data Type: datetime
Dimension: Time format (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[time_format]
Data Type: string
Dimension: Time zone (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[time_zone]
Data Type: string
Dimension: Title (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[title]
Data Type: string
Dimension: u (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[u_u]
Data Type: string
Dimension: User ID (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[user_name]
Data Type: string
Dimension: Password (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[user_password]
Data Type: string
Dimension: VIP (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[vip]
Data Type: boolean
Dimension: Web service access only (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[web_service_access_only]
Data Type: boolean
Dimension: Zip / Postal code (OpenedBy)
Role: Discrete Dimension
Remote Column: [OpenedBy].[zip]
Data Type: string
Calculated/Other
Dimension: Measure Names
Role: Discrete Dimension
Data Type: string
Dimension: Active (Excluding Resolved)
Role: Discrete Dimension
Data Type: string
Formula: IF [active]=FALSE OR [incident_state]="4"
THEN "Closed/Resolved"
ELSE
"Active"
END
Dimension: Ticket URL
Role: Discrete Dimension
Data Type: string
Formula: // This is a calculated field
// It updates the url to use the instance name added by the user
"https://"+[Instance Name]+".service-now.com/nav_to.do?uri=incident.do?sys_id="+[sys_id]
Dimension: Instance Name
Role: Discrete Dimension
Data Type: string
Formula: // This is a calculated field
// It gets any value typed in the parameter "Instance Name"
[Parameters].[Parameter 1]
Dimension: Overdue?
Role: Discrete Dimension
Data Type: string
Formula: // This is a calculated field using If statement
// For active incidents, it shows a mark for those that are overdue
IF [active]=TRUE
THEN
(IF DATEDIFF('second',[due_date], NOW())> 0
THEN "●"
END)
ELSE ""
END
Dimension: True/False Max Due Date
Role: Discrete Dimension
Data Type: boolean
Formula: // It is a calculated field using a level of detail calculation (LOD)
// It shows TRUE/FALSE if due date is equal maximum due date
{FIXED [number]: MAX([due_date])}
= [due_date]
Measure
AssignedTo
Measure: Calendar integration
Role: Continous Measure
Remote Column: [AssignedTo].[calendar_integration]
Data Type: integer
Measure: Failed login attempts
Role: Continous Measure
Remote Column: [AssignedTo].[failed_attempts]
Data Type: integer
Measure: Notification
Role: Continous Measure
Remote Column: [AssignedTo].[notification]
Data Type: integer
Measure: Updates (AssignedTo)
Role: Continous Measure
Remote Column: [AssignedTo].[sys_mod_count]
Data Type: integer
ClosedBy
Measure: Calendar integration (ClosedBy)
Role: Continous Measure
Remote Column: [ClosedBy].[calendar_integration]
Data Type: integer
Measure: Failed login attempts (ClosedBy)
Role: Continous Measure
Remote Column: [ClosedBy].[failed_attempts]
Data Type: integer
Measure: Notification (ClosedBy)
Role: Continous Measure
Remote Column: [ClosedBy].[notification]
Data Type: integer
Measure: Updates (ClosedBy)
Role: Continous Measure
Remote Column: [ClosedBy].[sys_mod_count]
Data Type: integer
Configuration Item
Measure: Fault count
Role: Continous Measure
Remote Column: [Configuration Item].[fault_count]
Data Type: integer
Measure: Operational status
Role: Continous Measure
Remote Column: [Configuration Item].[operational_status]
Data Type: integer
Measure: Updates (Configuration Item)
Role: Continous Measure
Remote Column: [Configuration Item].[sys_mod_count]
Data Type: integer
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
OpenedBy
Measure: Calendar integration (OpenedBy)
Role: Continous Measure
Remote Column: [OpenedBy].[calendar_integration]
Data Type: integer
Measure: Failed login attempts (OpenedBy)
Role: Continous Measure
Remote Column: [OpenedBy].[failed_attempts]
Data Type: integer
Measure: Notification (OpenedBy)
Role: Continous Measure
Remote Column: [OpenedBy].[notification]
Data Type: integer
Measure: Updates (OpenedBy)
Role: Continous Measure
Remote Column: [OpenedBy].[sys_mod_count]
Data Type: integer
Calculated/Other
Measure: Total Incidents
Role: Continous Measure
Data Type: integer
Formula: // This is a calculated field
// It counts each distinct incident
COUNTD([number])
Measure: % of Critical and High Priority
Role: Discrete Measure
Data Type: real
Formula: // This is a calculation
// It calculates the proportion of critical and high priority incidents
COUNTD(IF [priority]="1"
OR [priority]="2"
THEN [number]
END)
/
COUNTD([number])
Measure: Reopened Incidents
Role: Continous Measure
Data Type: integer
Formula: // This is a calculated field using level of detail calculation (LOD) and an if statement
// It counts each distinct incident that is a reopened ticket
COUNTD(IF { FIXED [number]:
SUM([Number of Records])} > 1
THEN [number]
END)
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([Incidents Age (Seconds)])/86400))
+ " day(s) " +
IF (INT(AVG(([Incidents Age (Seconds)]))%86400/3600))
< 10 THEN "0" ELSE "" END + STR(INT(AVG(([Incidents Age (Seconds)]))%86400/3600))
+ ":" +
IF INT(AVG(([Incidents Age (Seconds)]))%3600/60)
< 10 THEN "0" ELSE "" END + STR(INT(AVG(([Incidents Age (Seconds)]))%3600/60))
+ ":" +
IF INT(AVG(([Incidents Age (Seconds)])) %3600 %60)
< 10 THEN "0" ELSE "" END + STR(INT(AVG(([Incidents Age (Seconds)])) %3600 %60))
Measure: Incidents 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
DATEDIFF("second", [opened_at], NOW())
Measure: Show Group
Role: Discrete Measure
Data Type: string
Formula: // It is a calculated field
// It shows the name of a group when the dashboard is filtered
IF COUNTD([name (Group)])=1
THEN ATTR([name (Group)])
ELSE "Showing All Groups"
END
Measure: Number of Overdue
Role: Continous Measure
Data Type: integer
Formula: // This is a calculated field using a COUNTD expression
// It counts each distinct overdue incident
COUNTD(IF DATEDIFF('second',[due_date], NOW())> 0
THEN [number]
END)
Measure: Measure Values
Role: Continous Measure
Data Type: real
Measure: Number of Records
Role: Continous Measure
Data Type: integer
Formula: 1
Measure: Show Priority
Role: Discrete Measure
Data Type: string
Formula: // This is a calculated field
// It shows the priority when the dashboard is filtered
IF COUNTD([priority])=1
THEN "| "+ATTR([priority])
ELSE ""
END
Measure: Show Assignees
Role: Discrete Measure
Data Type: string
Formula: // It is a calculated field
// It shows the name of an assignee when the dashboard is filtered
IF COUNTD([name])=1
THEN ATTR([name])
ELSE "All Assignees"
END
Parameter
Calculated/Other
Measure: Instance Name
Role: Discrete Measure
Data Type: string
Formula: ""
Default Value: ""
Parameter Type: any
Semantic Values
[Country].[Name]: "Reino Unido"
Dashboards
Dashboard: Incident Tracker
Worksheets
Worksheet: Show Group
Datasources: Incidents
Used Dimensions & Measures: [Active (Excluding Resolved)]
[Active]
[Category]
[Incident state]
[Name (Group)]
[Name]
[Opened]
[Priority]
[Show Assignees]
[Show Group]
[Subcategory]
Used Remote Columns: [AssignedTo].[name]
[Group].[name]
[Incident].[active]
[Incident].[category]
[Incident].[incident_state]
[Incident].[opened_at]
[Incident].[priority]
[Incident].[subcategory]
Worksheet: Active Incidents
Datasources: Incidents
Used Dimensions & Measures: [% of Critical and High Priority]
[Active (Excluding Resolved)]
[Active]
[Average Age (DD:HH:MM:SS)]
[Category]
[Due date]
[Incident state]
[Incidents Age (Seconds)]
[Name (Group)]
[Name]
[Number of Overdue]
[Number of Records]
[Number]
[Opened]
[Priority]
[Reopened Incidents]
[Subcategory]
[Total Incidents]
Used Remote Columns: [AssignedTo].[name]
[Group].[name]
[Incident].[active]
[Incident].[category]
[Incident].[due_date]
[Incident].[incident_state]
[Incident].[number]
[Incident].[opened_at]
[Incident].[priority]
[Incident].[subcategory]
Worksheet: Opened Day of Active Incidents
Datasources: Incidents
Used Dimensions & Measures: [Active (Excluding Resolved)]
[Active]
[Category]
[Incident state]
[Name (Group)]
[Name]
[Number]
[Opened]
[Priority]
[Subcategory]
Used Remote Columns: [AssignedTo].[name]
[Group].[name]
[Incident].[active]
[Incident].[category]
[Incident].[incident_state]
[Incident].[number]
[Incident].[opened_at]
[Incident].[priority]
[Incident].[subcategory]
Worksheet: Incidents by Category and Subcategory
Datasources: Incidents
Used Dimensions & Measures: [Active (Excluding Resolved)]
[Active]
[Average Age (DD:HH:MM:SS)]
[Category]
[Incident state]
[Incidents Age (Seconds)]
[Name (Group)]
[Name]
[Number]
[Opened]
[Priority]
[Subcategory]
Used Remote Columns: [AssignedTo].[name]
[Group].[name]
[Incident].[active]
[Incident].[category]
[Incident].[incident_state]
[Incident].[number]
[Incident].[opened_at]
[Incident].[priority]
[Incident].[subcategory]
Worksheet: Active Incidents List
Datasources: Incidents
Parameters
Used Dimensions & Measures: [Active (Excluding Resolved)]
[Active]
[Category]
[Description]
[Due date]
[Incident state]
[Instance Name]
[Instance Name]
[Name (Group)]
[Name]
[Number]
[Opened]
[Overdue?]
[Priority]
[Subcategory]
[Sys ID]
[Ticket URL]
[True/False Max Due Date]
Used Remote Columns: [AssignedTo].[name]
[Group].[name]
[Incident].[active]
[Incident].[category]
[Incident].[description]
[Incident].[due_date]
[Incident].[incident_state]
[Incident].[number]
[Incident].[opened_at]
[Incident].[priority]
[Incident].[subcategory]
[Incident].[sys_id]
Dashboard Objects:
Filter: [Incidents].[MY(opened_at)]
Filter: [Incidents].[name (Group)]
Filter: [Incidents].[name]
Filter: [Incidents].[priority]
Text: Active Incident Tracker
Text: Incidents |
Worksheets
Worksheet: Active Incidents
Visible: No
Used Datasources
Datasource: Incidents
Discrete Dimension: Active (Excluding Resolved)
Discrete Dimension: Active
Remote Column: [Incident].[active]
Discrete Dimension: Category
Remote Column: [Incident].[category]
Discrete Dimension: Due date
Remote Column: [Incident].[due_date]
Discrete Dimension: Incident state
Remote Column: [Incident].[incident_state]
Discrete Dimension: Name (Group)
Remote Column: [Group].[name]
Discrete Dimension: Name
Remote Column: [AssignedTo].[name]
Discrete Dimension: Number
Remote Column: [Incident].[number]
Discrete Dimension: Opened
Remote Column: [Incident].[opened_at]
Discrete Dimension: Priority
Remote Column: [Incident].[priority]
Discrete Dimension: Subcategory
Remote Column: [Incident].[subcategory]
Continous Measure: Total Incidents
Discrete Measure: % of Critical and High Priority
Continous Measure: Reopened Incidents
Discrete Measure: Average Age (DD:HH:MM:SS)
Continous Measure: Incidents Age (Seconds)
Continous Measure: Number of Overdue
Continous Measure: Number of Records
Marks
Mark: All
Type: Automatic
Label: <[Incidents].[Multiple Values]>
View
Rows: [Incidents].[Average Age (DD:HH:MM:SS)]
Columns: [Incidents].[Measure Names()]
Filters: [Incidents].[Measure Names()]
[Incidents].[Action (Category,Subcategory)]
[Incidents].[Action (DAY(Opened))]
[Incidents].[MY(opened_at)]
[Incidents].[Active (Excluding Resolved)]
[Incidents].[name (Group)]
[Incidents].[name]
[Incidents].[priority]
Manual Sorting: [Incidents].[Measure Names()] ASC
Slices: [Incidents].[name (Group)]
[Incidents].[name]
[Incidents].[Action (Category,Subcategory)]
[Incidents].[Measure Names()]
[Incidents].[priority]
[Incidents].[MY(opened_at)]
[Incidents].[Action (DAY(Opened))]
[Incidents].[Active (Excluding Resolved)]
Styles
Style: cell
[Incidents].[Number of Overdue]
text-format: N
Style: header
[Incidents].[Average Age (DD:HH:MM:SS)]
width: 406
[Incidents].[Measure Names()]
height: 34
background-color: #f2f2f3
rows
band-color: #00000000
Style: field-labels
Other
font-size: 9
font-family: Tableau Regular
color: #333333
background-color: #f2f2f3
Style: label
[Incidents].[Average Age (DD:HH:MM:SS)]
text-align: center
vertical-align: center
font-family: Tableau Regular
font-size: 14
[Incidents].[Measure Names()]
font-weight: normal
text-align: center
vertical-align: center
font-family: Tableau Regular
Style: pane
Other
border-style: none
rows
band-color: #00000000
Style: table
Other
background-color: #00000000
rows
band-size: 1
Style: table-div
rows
line-visibility: off
cols
stroke-size: 5
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff
div-level: 1
Style: title
Other
background-color: #f2f2f3
Worksheet: Active Incidents List
Visible: No
Used Datasources
Datasource: Parameters
Discrete Measure: Instance Name
Datasource: Incidents
Discrete Dimension: Active (Excluding Resolved)
Discrete Dimension: Ticket URL
Discrete Dimension: Instance Name
Discrete Dimension: Overdue?
Discrete Dimension: True/False Max Due Date
Discrete Dimension: Active
Remote Column: [Incident].[active]
Discrete Dimension: Category
Remote Column: [Incident].[category]
Discrete Dimension: Description
Remote Column: [Incident].[description]
Discrete Dimension: Due date
Remote Column: [Incident].[due_date]
Discrete Dimension: Incident state
Remote Column: [Incident].[incident_state]
Discrete Dimension: Name (Group)
Remote Column: [Group].[name]
Discrete Dimension: Name
Remote Column: [AssignedTo].[name]
Discrete Dimension: Number
Remote Column: [Incident].[number]
Discrete Dimension: Opened
Remote Column: [Incident].[opened_at]
Discrete Dimension: Priority
Remote Column: [Incident].[priority]
Discrete Dimension: Subcategory
Remote Column: [Incident].[subcategory]
Discrete Dimension: Sys ID
Remote Column: [Incident].[sys_id]
Marks
Mark: All
Type: Shape
Tooltip: Incident Number: <[Incidents].[number]>
Description: <[Incidents].[description]>
Due Date: <[Incidents].[due_date]>
Assigned To: <[Incidents].[name]>
Click to see option to navigate to ServiceNow.
Before using the SN link, please add Instance Name in the field above (not available in Mobile)
View
Rows: [Incidents].[number]
([Incidents].[Overdue?]
([Incidents].[description]
([Incidents].[due_date]
[Incidents].[name]))))
Filters: [Incidents].[Action (Category,Subcategory)]
[Incidents].[Action (DAY(Opened))]
[Incidents].[MY(opened_at)]
[Incidents].[Active (Excluding Resolved)]
[Incidents].[True/False Max Due Date]
[Incidents].[name (Group)]
[Incidents].[name]
[Incidents].[priority]
Slices: [Incidents].[True/False Max Due Date]
[Incidents].[name (Group)]
[Incidents].[name]
[Incidents].[Action (Category,Subcategory)]
[Incidents].[priority]
[Incidents].[MY(opened_at)]
[Incidents].[Action (DAY(Opened))]
[Incidents].[Active (Excluding Resolved)]
Styles
Style: axis
Other
border-color: #b0b0b0
border-width: 1
Style: cell
[Incidents].[name]
height: 31
[Incidents].[description]
font-size: 8
Style: header
[Incidents].[Ticket URL]
width: 816
[Incidents].[number]
width: 100
[Incidents].[Overdue?]
width: 84
[Incidents].[description]
width: 300
[Incidents].[due_date]
width: 148
[Incidents].[name]
width: 164
Other
height-header: 20
Style: field-labels
Other
font-family: Tableau Bold
font-size: 8
background-color: #ffffff
color: #555555
Style: field-labels-decoration
Other
text-align: left
vertical-align: center
Style: label
[Incidents].[number]
display: true
font-size: 8
font-family: Tableau Book
[Incidents].[Overdue?]
font-size: 14
color: #ff4346
text-align: center
[Incidents].[description]
font-size: 8
font-family: Tableau Book
[Incidents].[name]
font-size: 8
font-family: Tableau Book
[Incidents].[due_date]
font-size: 8
font-family: Tableau Book
Style: table
Other
row-levels: 16
row-horiz-levels: 16
col-levels: 16
Style: table-div
cols
line-visibility: off
Style: title
Other
background-color: #f2f2f3
Worksheet: Incidents by Category and Subcategory
Visible: No
Used Datasources
Datasource: Incidents
Discrete Dimension: Active (Excluding Resolved)
Discrete Dimension: Active
Remote Column: [Incident].[active]
Discrete Dimension: Category
Remote Column: [Incident].[category]
Discrete Dimension: Incident state
Remote Column: [Incident].[incident_state]
Discrete Dimension: Name (Group)
Remote Column: [Group].[name]
Discrete Dimension: Name
Remote Column: [AssignedTo].[name]
Discrete Dimension: Number
Remote Column: [Incident].[number]
Discrete Dimension: Opened
Remote Column: [Incident].[opened_at]
Discrete Dimension: Priority
Remote Column: [Incident].[priority]
Discrete Dimension: Subcategory
Remote Column: [Incident].[subcategory]
Discrete Measure: Average Age (DD:HH:MM:SS)
Continous Measure: Incidents Age (Seconds)
Marks
Mark: All
Type: Automatic
Label: <[Incidents].[category]>
<[Incidents].[subcategory]>
Tooltip: <[Incidents].[category]> <[Incidents].[subcategory]>
<[Incidents].[number]> active incidents
Average Age: <[Incidents].[Average Age (DD:HH:MM:SS)]>
View
Filters: [Incidents].[Action (DAY(Opened))]
[Incidents].[MY(opened_at)]
[Incidents].[Active (Excluding Resolved)]
[Incidents].[name (Group)]
[Incidents].[name]
[Incidents].[priority]
Slices: [Incidents].[name (Group)]
[Incidents].[name]
[Incidents].[MY(opened_at)]
[Incidents].[priority]
[Incidents].[Action (DAY(Opened))]
[Incidents].[Active (Excluding Resolved)]
Styles
Style: title
Other
background-color: #f5f5f5
Style: legend
Other
font-size: 8
font-family: Tableau Book
Style: legend-title
Other
font-family: Tableau Book
font-size: 8
text-align: center
Style: legend-title-text
[Incidents].[AVG(Incidents Age (Seconds))]
color: Age:
Style: quick-filter
[Incidents].[name]
title: Assignee:
[Incidents].[name (Group)]
title: Group:
[Incidents].[MY(opened_at)]
title: Opened:
[Incidents].[priority]
title: Priority:
Other
font-size: 8
font-family: Tableau Light
border-width: 5
border-style: none
background-color: #ffffff89
Style: quick-filter-title
Other
font-size: 8
text-align: left
font-family: Tableau Regular
font-weight: normal
Worksheet: Opened Day of Active Incidents
Visible: No
Used Datasources
Datasource: Incidents
Discrete Dimension: Active (Excluding Resolved)
Discrete Dimension: Active
Remote Column: [Incident].[active]
Discrete Dimension: Category
Remote Column: [Incident].[category]
Discrete Dimension: Incident state
Remote Column: [Incident].[incident_state]
Discrete Dimension: Name (Group)
Remote Column: [Group].[name]
Discrete Dimension: Name
Remote Column: [AssignedTo].[name]
Discrete Dimension: Number
Remote Column: [Incident].[number]
Discrete Dimension: Opened
Remote Column: [Incident].[opened_at]
Discrete Dimension: Priority
Remote Column: [Incident].[priority]
Discrete Dimension: Subcategory
Remote Column: [Incident].[subcategory]
Marks
Mark: All
Type: Bar
Tooltip: <[Incidents].[DAY(opened_at)]>
<[Incidents].[number]> incident(s)
View
Rows: [Incidents].[number]
Columns: [Incidents].[DAY(opened_at)]
Filters: [Incidents].[Action (Category,Subcategory)]
[Incidents].[MY(opened_at)]
[Incidents].[Active (Excluding Resolved)]
[Incidents].[name (Group)]
[Incidents].[name]
[Incidents].[priority]
Slices: [Incidents].[Action (Category,Subcategory)]
[Incidents].[priority]
[Incidents].[name]
[Incidents].[MY(opened_at)]
[Incidents].[name (Group)]
[Incidents].[Active (Excluding Resolved)]
Styles
Style: axis
[Incidents].[number]
auto-subtitle: true
[Incidents].[DAY(opened_at)]
auto-subtitle: true
Other
line-visibility: on
line-pattern-only: solid
stroke-size: 1
stroke-color: #e6e6e6
cols
line-visibility: on
line-pattern-only: solid
rows
tick-color: #00000000
line-visibility: off
Style: label
[Incidents].[DAY(opened_at)]
font-family: Tableau Light
font-size: 8
[Incidents].[number]
font-size: 8
Style: worksheet
rows
display-field-labels: false
Other
font-size: 9
font-family: Tableau Light
Style: title
Other
background-color: #f2f2f3
Worksheet: Sheet 1
Visible: No
Marks
Mark: All
Type: Automatic
View
Worksheet: Show Group
Visible: No
Used Datasources
Datasource: Incidents
Discrete Dimension: Active (Excluding Resolved)
Discrete Dimension: Active
Remote Column: [Incident].[active]
Discrete Dimension: Category
Remote Column: [Incident].[category]
Discrete Dimension: Incident state
Remote Column: [Incident].[incident_state]
Discrete Dimension: Name (Group)
Remote Column: [Group].[name]
Discrete Dimension: Name
Remote Column: [AssignedTo].[name]
Discrete Dimension: Opened
Remote Column: [Incident].[opened_at]
Discrete Dimension: Priority
Remote Column: [Incident].[priority]
Discrete Dimension: Subcategory
Remote Column: [Incident].[subcategory]
Discrete Measure: Show Group
Discrete Measure: Show Assignees
Marks
Mark: All
Type: Automatic
Label: <[Incidents].[Show Group]> and <[Incidents].[Show Group (copy)]>
Tooltip: Click on the filter below to show values for a specific group or assignee
View
Filters: [Incidents].[Action (Category,Subcategory)]
[Incidents].[Action (DAY(Opened))]
[Incidents].[MY(opened_at)]
[Incidents].[Active (Excluding Resolved)]
[Incidents].[name (Group)]
[Incidents].[name]
[Incidents].[priority]
Slices: [Incidents].[name (Group)]
[Incidents].[Action (Category,Subcategory)]
[Incidents].[priority]
[Incidents].[name]
[Incidents].[MY(opened_at)]
[Incidents].[Action (DAY(Opened))]
[Incidents].[Active (Excluding Resolved)]
Styles
Style: cell
Other
border-color: #e6e6e6
border-style: none
Style: header
Other
border-style: none
border-style: none
Style: pane
Other
border-style: none
border-style: none
Style: table
Other
background-color: #f5f5f5
Style: worksheet
Other
font-family: Tableau Regular
font-size: 22
color: #9b9b9b
Style: title
Other
background-color: #e6e6e6