**************************************************************************** Location : Tableau Server Host : http://bnbrepository9/#/ Path : Tableau Samples/Incident-Tracker **************************************************************************** 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