Workbook Information
Author: Unknown
Embedded Datasources
Datasource: Problems
Connection
Data Sources
Data Source: Problems
Attributes
channel: http
class: sqlproxy
dbname: Problems
directory: /dataserver
port: 80
server: bnbrepository9
username: {"user":"","apiInstance":""}
workgroup-auth-mode: prompt
Tables
Table: sqlproxy
Database Object: [sqlproxy]
Connection: Problems
Dimension
sqlproxy
Dimension: Time Span Breakdown
Role: Discrete Dimension
Remote Column: [sqlproxy].[Calculation_217580207391584262]
Data Type: string
Formula: // This is a calculated field
// It groups problems accordingly with their ages
IF [Age of Problems]< 2592000
THEN "Under 30 d"
ELSEIF [Age of Problems] > 7776000
THEN "+ than 90d"
ELSE " 30-90 d"
END
Aggregation: Count
Dimension: Overdue
Role: Discrete Dimension
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Data Type: string
Formula: // This is a calculated field
// It checks if an incident is overdue
//Check overdue cases among inactive incidents
{ FIXED [number]:
IF MAX([active]=FALSE)
AND
max([closed_at])> max([due_date])
OR
//Check overdue cases among active incidents
MAX([active]=TRUE)
AND NOW()> MAX([due_date])
THEN "Overdue"
END
}
Aggregation: Count
Dimension: Max Year?
Role: Discrete Dimension
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Data Type: boolean
Formula: // This is a calculated field
// It shows TRUE/FALSE if the year of opened is equal the max year of the dataset
DATEPART("year", [opened_at]) = DATEPART("year", {MAX([opened_at])})
Aggregation: Count
Dimension: Active (Group)
Role: Discrete Dimension
Remote Column: [sqlproxy].[active (Group)]
Data Type: boolean
Aggregation: Count
Dimension: Active (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[active (Problem)]
Data Type: boolean
Aggregation: Count
Dimension: Active
Role: Discrete Dimension
Remote Column: [sqlproxy].[active]
Data Type: boolean
Aggregation: Count
Dimension: Activity due (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[activity_due (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Activity due
Role: Discrete Dimension
Remote Column: [sqlproxy].[activity_due]
Data Type: datetime
Aggregation: Year
Dimension: Additional assignee list (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[additional_assignee_list (Problem)]
Data Type: string
Aggregation: Count
Dimension: Additional assignee list
Role: Discrete Dimension
Remote Column: [sqlproxy].[additional_assignee_list]
Data Type: string
Aggregation: Count
Dimension: Approval (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval (Problem)]
Data Type: string
Aggregation: Count
Dimension: Approval
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval]
Data Type: string
Aggregation: Count
Dimension: Approval history (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_history (Problem)]
Data Type: string
Aggregation: Count
Dimension: Approval history
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_history]
Data Type: string
Aggregation: Count
Dimension: Approval set (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_set (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Approval set
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_set]
Data Type: datetime
Aggregation: Year
Dimension: Assigned to (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[assigned_to (Problem)]
Data Type: string
Aggregation: Count
Dimension: Assigned to
Role: Discrete Dimension
Remote Column: [sqlproxy].[assigned_to]
Data Type: string
Aggregation: Count
Dimension: Assignment group (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[assignment_group (Problem)]
Data Type: string
Aggregation: Count
Dimension: Assignment group
Role: Discrete Dimension
Remote Column: [sqlproxy].[assignment_group]
Data Type: string
Aggregation: Count
Dimension: Business duration (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_duration (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Business duration
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_duration]
Data Type: datetime
Aggregation: Year
Dimension: Business service (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_service (Problem)]
Data Type: string
Aggregation: Count
Dimension: Business service
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_service]
Data Type: string
Aggregation: Count
Dimension: Duration (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[calendar_duration (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Duration
Role: Discrete Dimension
Remote Column: [sqlproxy].[calendar_duration]
Data Type: datetime
Aggregation: Year
Dimension: Close notes (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[close_notes (Problem)]
Data Type: string
Aggregation: Count
Dimension: Close notes
Role: Discrete Dimension
Remote Column: [sqlproxy].[close_notes]
Data Type: string
Aggregation: Count
Dimension: Closed (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_at (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Closed
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_at]
Data Type: datetime
Aggregation: Year
Dimension: Closed by (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_by (Problem)]
Data Type: string
Aggregation: Count
Dimension: Closed by
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_by]
Data Type: string
Aggregation: Count
Dimension: Configuration item (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[cmdb_ci (Problem)]
Data Type: string
Aggregation: Count
Dimension: Configuration item
Role: Discrete Dimension
Remote Column: [sqlproxy].[cmdb_ci]
Data Type: string
Aggregation: Count
Dimension: Additional comments (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments (Problem)]
Data Type: string
Aggregation: Count
Dimension: Additional comments
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments]
Data Type: string
Aggregation: Count
Dimension: Comments and Work notes (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments_and_work_notes (Problem)]
Data Type: string
Aggregation: Count
Dimension: Comments and Work notes
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments_and_work_notes]
Data Type: string
Aggregation: Count
Dimension: Company (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[company (Problem)]
Data Type: string
Aggregation: Count
Dimension: Company
Role: Discrete Dimension
Remote Column: [sqlproxy].[company]
Data Type: string
Aggregation: Count
Dimension: Contact type (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[contact_type (Problem)]
Data Type: string
Aggregation: Count
Dimension: Contact type
Role: Discrete Dimension
Remote Column: [sqlproxy].[contact_type]
Data Type: string
Aggregation: Count
Dimension: Correlation display (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_display (Problem)]
Data Type: string
Aggregation: Count
Dimension: Correlation display
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_display]
Data Type: string
Aggregation: Count
Dimension: Correlation ID (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_id (Problem)]
Data Type: string
Aggregation: Count
Dimension: Correlation ID
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_id]
Data Type: string
Aggregation: Count
Dimension: Cost center
Role: Discrete Dimension
Remote Column: [sqlproxy].[cost_center]
Data Type: string
Aggregation: Count
Dimension: Default assignee
Role: Discrete Dimension
Remote Column: [sqlproxy].[default_assignee]
Data Type: string
Aggregation: Count
Dimension: Delivery plan (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_plan (Problem)]
Data Type: string
Aggregation: Count
Dimension: Delivery plan
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_plan]
Data Type: string
Aggregation: Count
Dimension: Delivery task (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_task (Problem)]
Data Type: string
Aggregation: Count
Dimension: Delivery task
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_task]
Data Type: string
Aggregation: Count
Dimension: Description (Group)
Role: Discrete Dimension
Remote Column: [sqlproxy].[description (Group)]
Data Type: string
Aggregation: Count
Dimension: Description (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[description (Problem)]
Data Type: string
Aggregation: Count
Dimension: Description
Role: Discrete Dimension
Remote Column: [sqlproxy].[description]
Data Type: string
Aggregation: Count
Dimension: Due date (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[due_date (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Due date
Role: Discrete Dimension
Remote Column: [sqlproxy].[due_date]
Data Type: datetime
Aggregation: Year
Dimension: Group email
Role: Discrete Dimension
Remote Column: [sqlproxy].[email]
Data Type: string
Aggregation: Count
Dimension: Exclude manager
Role: Discrete Dimension
Remote Column: [sqlproxy].[exclude_manager]
Data Type: boolean
Aggregation: Count
Dimension: Expected start (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[expected_start (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Expected start
Role: Discrete Dimension
Remote Column: [sqlproxy].[expected_start]
Data Type: datetime
Aggregation: Year
Dimension: Follow up (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[follow_up (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Follow up
Role: Discrete Dimension
Remote Column: [sqlproxy].[follow_up]
Data Type: datetime
Aggregation: Year
Dimension: Group list (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[group_list (Problem)]
Data Type: string
Aggregation: Count
Dimension: Group list
Role: Discrete Dimension
Remote Column: [sqlproxy].[group_list]
Data Type: string
Aggregation: Count
Dimension: Include members
Role: Discrete Dimension
Remote Column: [sqlproxy].[include_members]
Data Type: boolean
Aggregation: Count
Dimension: Knowledge (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[knowledge (Problem)]
Data Type: boolean
Aggregation: Count
Dimension: Knowledge
Role: Discrete Dimension
Remote Column: [sqlproxy].[knowledge]
Data Type: boolean
Aggregation: Count
Dimension: Known error
Role: Discrete Dimension
Remote Column: [sqlproxy].[known_error]
Data Type: boolean
Aggregation: Count
Dimension: Location (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[location (Problem)]
Data Type: string
Aggregation: Count
Dimension: Location
Role: Discrete Dimension
Remote Column: [sqlproxy].[location]
Data Type: string
Aggregation: Count
Dimension: Made SLA (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[made_sla (Problem)]
Data Type: boolean
Aggregation: Count
Dimension: Made SLA
Role: Discrete Dimension
Remote Column: [sqlproxy].[made_sla]
Data Type: boolean
Aggregation: Count
Dimension: Manager
Role: Discrete Dimension
Remote Column: [sqlproxy].[manager]
Data Type: string
Aggregation: Count
Dimension: Name
Role: Discrete Dimension
Remote Column: [sqlproxy].[name]
Data Type: string
Aggregation: Count
Dimension: Number (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[number (Problem)]
Data Type: string
Aggregation: Count
Dimension: Number
Role: Discrete Dimension
Remote Column: [sqlproxy].[number]
Data Type: string
Aggregation: Count
Dimension: Opened (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_at (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Opened
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_at]
Data Type: datetime
Aggregation: Year
Dimension: Opened by (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_by (Problem)]
Data Type: string
Aggregation: Count
Dimension: Opened by
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_by]
Data Type: string
Aggregation: Count
Dimension: Parent (Group)
Role: Discrete Dimension
Remote Column: [sqlproxy].[parent (Group)]
Data Type: string
Aggregation: Count
Dimension: Parent (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[parent (Problem)]
Data Type: string
Aggregation: Count
Dimension: Parent
Role: Discrete Dimension
Remote Column: [sqlproxy].[parent]
Data Type: string
Aggregation: Count
Dimension: Priority
Role: Discrete Dimension
Remote Column: [sqlproxy].[priority]
Data Type: integer
Aggregation: Sum
Dimension: Change request
Role: Discrete Dimension
Remote Column: [sqlproxy].[rfc]
Data Type: string
Aggregation: Count
Dimension: Roles
Role: Discrete Dimension
Remote Column: [sqlproxy].[roles]
Data Type: string
Aggregation: Count
Dimension: Short description (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[short_description (Problem)]
Data Type: string
Aggregation: Count
Dimension: Short description
Role: Discrete Dimension
Remote Column: [sqlproxy].[short_description]
Data Type: string
Aggregation: Count
Dimension: SLA due (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sla_due (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: SLA due
Role: Discrete Dimension
Remote Column: [sqlproxy].[sla_due]
Data Type: datetime
Aggregation: Year
Dimension: Source
Role: Discrete Dimension
Remote Column: [sqlproxy].[source]
Data Type: string
Aggregation: Count
Dimension: Task type (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_class_name (Problem)]
Data Type: string
Aggregation: Count
Dimension: Task type
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_class_name]
Data Type: string
Aggregation: Count
Dimension: Created by (Group)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_by (Group)]
Data Type: string
Aggregation: Count
Dimension: Created by (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_by (Problem)]
Data Type: string
Aggregation: Count
Dimension: Created by
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_by]
Data Type: string
Aggregation: Count
Dimension: Created (Group)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_on (Group)]
Data Type: datetime
Aggregation: Year
Dimension: Created (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_on (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Created
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_on]
Data Type: datetime
Aggregation: Year
Dimension: Domain (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain (Problem)]
Data Type: string
Aggregation: Count
Dimension: Domain
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain]
Data Type: string
Aggregation: Count
Dimension: Domain Path (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain_path (Problem)]
Data Type: string
Aggregation: Count
Dimension: Domain Path
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain_path]
Data Type: string
Aggregation: Count
Dimension: Sys ID (Group)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_id (Group)]
Data Type: string
Aggregation: Count
Dimension: Sys ID (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_id (Problem)]
Data Type: string
Aggregation: Count
Dimension: Sys ID
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_id]
Data Type: string
Aggregation: Count
Dimension: Updated by (Group)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_by (Group)]
Data Type: string
Aggregation: Count
Dimension: Updated by (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_by (Problem)]
Data Type: string
Aggregation: Count
Dimension: Updated by
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_by]
Data Type: string
Aggregation: Count
Dimension: Updated (Group)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_on (Group)]
Data Type: datetime
Aggregation: Year
Dimension: Updated (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_on (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Updated
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_on]
Data Type: datetime
Aggregation: Year
Dimension: Time worked (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[time_worked (Problem)]
Data Type: string
Aggregation: Count
Dimension: Time worked
Role: Discrete Dimension
Remote Column: [sqlproxy].[time_worked]
Data Type: string
Aggregation: Count
Dimension: Type
Role: Discrete Dimension
Remote Column: [sqlproxy].[type]
Data Type: string
Aggregation: Count
Dimension: u_
Role: Discrete Dimension
Remote Column: [sqlproxy].[u_lu2]
Data Type: string
Aggregation: Count
Dimension: Lucha
Role: Discrete Dimension
Remote Column: [sqlproxy].[u_lucha]
Data Type: string
Aggregation: Count
Dimension: u
Role: Discrete Dimension
Remote Column: [sqlproxy].[u_u]
Data Type: string
Aggregation: Count
Dimension: Upon approval (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_approval (Problem)]
Data Type: string
Aggregation: Count
Dimension: Upon approval
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_approval]
Data Type: string
Aggregation: Count
Dimension: Upon reject (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_reject (Problem)]
Data Type: string
Aggregation: Count
Dimension: Upon reject
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_reject]
Data Type: string
Aggregation: Count
Dimension: User input (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[user_input (Problem)]
Data Type: string
Aggregation: Count
Dimension: User input
Role: Discrete Dimension
Remote Column: [sqlproxy].[user_input]
Data Type: string
Aggregation: Count
Dimension: Watch list (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[watch_list (Problem)]
Data Type: string
Aggregation: Count
Dimension: Watch list
Role: Discrete Dimension
Remote Column: [sqlproxy].[watch_list]
Data Type: string
Aggregation: Count
Dimension: Workaround
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_around]
Data Type: string
Aggregation: Count
Dimension: Work end (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_end (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Work end
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_end]
Data Type: datetime
Aggregation: Year
Dimension: Work notes (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes (Problem)]
Data Type: string
Aggregation: Count
Dimension: Work notes
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes]
Data Type: string
Aggregation: Count
Dimension: Work notes list (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes_list (Problem)]
Data Type: string
Aggregation: Count
Dimension: Work notes list
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes_list]
Data Type: string
Aggregation: Count
Dimension: Work start (Problem)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_start (Problem)]
Data Type: datetime
Aggregation: Year
Dimension: Work start
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_start]
Data Type: datetime
Aggregation: Year
Calculated/Other
Dimension: Measure Names
Role: Discrete Dimension
Data Type: string
Aggregation: Count
Measure
sqlproxy
Measure: % of known error
Role: Continous Measure
Remote Column: [sqlproxy].[Calculation_217580207383207936]
Data Type: real
Formula: // This is a calculated field
// It shows the percentage of problems that are known errors
COUNTD(IF [known_error]=TRUE
THEN [number] END)
/
COUNTD([number])
Aggregation: User
Measure: Age of Problems
Role: Continous Measure
Remote Column: [sqlproxy].[Calculation_217580207388532741]
Data Type: integer
Formula: //Calculates the age of active problems since opened until now
DATEDIFF('second', [opened_at], NOW())
Aggregation: Sum
Measure: % of critical and high priority
Role: Continous Measure
Remote Column: [sqlproxy].[Calculation_217580207398023176]
Data Type: real
Formula: // This is a calculated field
// It shows the percentage of critical or high priority problems
COUNTD(IF [priority]=1
OR [priority]=2
THEN [number]
END)
/
COUNTD([number])
Aggregation: User
Measure: Problems with Related Incidents
Role: Discrete Measure
Remote Column: [sqlproxy].[Calculation_217580207400972297]
Data Type: integer
Formula: // This is a calculated field
// It counts each distinct problems which has a related incident
COUNT(IF ([related_incidents]>0
AND NOT ISNULL([related_incidents]))=true
THEN [number]
END)
Aggregation: User
Measure: Current Year Total Cases
Role: Continous Measure
Remote Column: [sqlproxy].[Calculation_466404086152966145]
Data Type: integer
Formula: // This is a calculated field
// It counts each disctinct problem. The "exclude" is used to avoid filters interfering with the result
{EXCLUDE [opened_at], [Overdue], [Max Year?]:
COUNTD(IF [Max Year?]=TRUE
THEN [number]
END)
}
Aggregation: Attribute
Measure: Total # Problems
Role: Continous Measure
Remote Column: [sqlproxy].[Calculation_466404086465376264]
Data Type: integer
Formula: // This is a calculated field using a level of detail calculation (LOD)
// It counts each distinct problems ignoring date
{ EXCLUDE [opened_at]: COUNTD([number])}
Aggregation: Attribute
Measure: Total Active Problems
Role: Continous Measure
Remote Column: [sqlproxy].[Current Year Total Cases (copy)]
Data Type: integer
Formula: // This is a calculated field using a level of detail calculation (LOD)
// It counts each distinct active problem. The "exclude" is used to avoid filters interfering with the result
{EXCLUDE [opened_at], [Overdue], [Max Year?]:
COUNTD(IF [active]=TRUE
THEN [number]
END)
}
Aggregation: Attribute
Measure: Escalation (Problem)
Role: Continous Measure
Remote Column: [sqlproxy].[escalation (Problem)]
Data Type: integer
Aggregation: Sum
Measure: Escalation
Role: Continous Measure
Remote Column: [sqlproxy].[escalation]
Data Type: integer
Aggregation: Sum
Measure: Impact (Problem)
Role: Continous Measure
Remote Column: [sqlproxy].[impact (Problem)]
Data Type: integer
Aggregation: Sum
Measure: Impact
Role: Continous Measure
Remote Column: [sqlproxy].[impact]
Data Type: integer
Aggregation: Sum
Measure: Order (Problem)
Role: Continous Measure
Remote Column: [sqlproxy].[order (Problem)]
Data Type: integer
Aggregation: Sum
Measure: Order
Role: Continous Measure
Remote Column: [sqlproxy].[order]
Data Type: integer
Aggregation: Sum
Measure: Priority (Problem)
Role: Continous Measure
Remote Column: [sqlproxy].[priority (Problem)]
Data Type: integer
Aggregation: Sum
Measure: Problem state
Role: Continous Measure
Remote Column: [sqlproxy].[problem_state]
Data Type: integer
Aggregation: Sum
Measure: Reassignment count (Problem)
Role: Continous Measure
Remote Column: [sqlproxy].[reassignment_count (Problem)]
Data Type: integer
Aggregation: Sum
Measure: Reassignment count
Role: Continous Measure
Remote Column: [sqlproxy].[reassignment_count]
Data Type: integer
Aggregation: Sum
Measure: Related Incidents
Role: Continous Measure
Remote Column: [sqlproxy].[related_incidents]
Data Type: integer
Aggregation: Sum
Measure: State (Problem)
Role: Continous Measure
Remote Column: [sqlproxy].[state (Problem)]
Data Type: integer
Aggregation: Sum
Measure: State
Role: Continous Measure
Remote Column: [sqlproxy].[state]
Data Type: integer
Aggregation: Sum
Measure: Updates (Group)
Role: Continous Measure
Remote Column: [sqlproxy].[sys_mod_count (Group)]
Data Type: integer
Aggregation: Sum
Measure: Updates (Problem)
Role: Continous Measure
Remote Column: [sqlproxy].[sys_mod_count (Problem)]
Data Type: integer
Aggregation: Sum
Measure: Updates
Role: Continous Measure
Remote Column: [sqlproxy].[sys_mod_count]
Data Type: integer
Aggregation: Sum
Measure: Urgency (Problem)
Role: Continous Measure
Remote Column: [sqlproxy].[urgency (Problem)]
Data Type: integer
Aggregation: Sum
Measure: Urgency
Role: Continous Measure
Remote Column: [sqlproxy].[urgency]
Data Type: integer
Aggregation: Sum
Measure: Number of Records
Role: Continous Measure
Remote Column: [sqlproxy].[Number of Records]
Data Type: integer
Aggregation: Sum
Calculated/Other
Measure: % of Overdue
Role: Continous Measure
Data Type: real
Formula: // This is a calculated field
// It shows the percentage of incidents that are overdue
IFNULL((IF ATTR([Overdue]= "Overdue")
THEN COUNTD([number])
END),0)
/
ATTR({ EXCLUDE [Overdue]:
COUNTD([number])})
Aggregation: User
Measure: Measure Values
Role: Continous Measure
Data Type: real
Aggregation: Sum
Semantic Values
[Country].[Name]: "United States"
Datasource: Requests
Connection
Data Sources
Data Source: Requests
Attributes
channel: http
class: sqlproxy
dbname: Requests
directory: /dataserver
port: 80
server: bnbrepository9
username: {"user":"","apiInstance":""}
workgroup-auth-mode: prompt
Tables
Table: sqlproxy
Database Object: [sqlproxy]
Connection: Requests
Dimension
sqlproxy
Dimension: Overdue
Role: Discrete Dimension
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Data Type: string
Formula: // This is a calculated field
// It shows if an accident is overdue
//Check overdue cases among inactive incidents
IF [active]=FALSE
AND
[closed_at]>[due_date]
OR
//Check overdue cases among active incidents
[active]=TRUE
AND NOW()>[due_date]
THEN "Overdue"
ELSE "Non Overdue"
END
Aggregation: Count
Dimension: Max Year?
Role: Discrete Dimension
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Data Type: boolean
Formula: // This is a calculated field
// It shows TRUE/FALSE if the year of opened is equal the maximum year in the dataset
DATEPART("year", [opened_at]) = DATEPART("year", {MAX([opened_at])})
Aggregation: Count
Dimension: Active (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[active (Catalog Item)]
Data Type: boolean
Aggregation: Count
Dimension: Active (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[active (Request)]
Data Type: boolean
Aggregation: Count
Dimension: Active (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[active (Requested Item)]
Data Type: boolean
Aggregation: Count
Dimension: Active
Role: Discrete Dimension
Remote Column: [sqlproxy].[active]
Data Type: boolean
Aggregation: Count
Dimension: Activity due (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[activity_due (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Activity due (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[activity_due (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Activity due
Role: Discrete Dimension
Remote Column: [sqlproxy].[activity_due]
Data Type: datetime
Aggregation: Year
Dimension: Additional assignee list (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[additional_assignee_list (Request)]
Data Type: string
Aggregation: Count
Dimension: Additional assignee list (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[additional_assignee_list (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Additional assignee list
Role: Discrete Dimension
Remote Column: [sqlproxy].[additional_assignee_list]
Data Type: string
Aggregation: Count
Dimension: Approval (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval (Request)]
Data Type: string
Aggregation: Count
Dimension: Approval (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Approval
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval]
Data Type: string
Aggregation: Count
Dimension: Approval history (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_history (Request)]
Data Type: string
Aggregation: Count
Dimension: Approval history (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_history (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Approval history
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_history]
Data Type: string
Aggregation: Count
Dimension: Approval set (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_set (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Approval set (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_set (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Approval set
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_set]
Data Type: datetime
Aggregation: Year
Dimension: Assigned to (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[assigned_to (Request)]
Data Type: string
Aggregation: Count
Dimension: Assigned to (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[assigned_to (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Assigned to
Role: Discrete Dimension
Remote Column: [sqlproxy].[assigned_to]
Data Type: string
Aggregation: Count
Dimension: Assignment group (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[assignment_group (Request)]
Data Type: string
Aggregation: Count
Dimension: Assignment group (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[assignment_group (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Assignment group
Role: Discrete Dimension
Remote Column: [sqlproxy].[assignment_group]
Data Type: string
Aggregation: Count
Dimension: Availability
Role: Discrete Dimension
Remote Column: [sqlproxy].[availability]
Data Type: string
Aggregation: Count
Dimension: Backordered
Role: Discrete Dimension
Remote Column: [sqlproxy].[backordered]
Data Type: boolean
Aggregation: Count
Dimension: Billable (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[billable (Catalog Item)]
Data Type: boolean
Aggregation: Count
Dimension: Billable
Role: Discrete Dimension
Remote Column: [sqlproxy].[billable]
Data Type: boolean
Aggregation: Count
Dimension: Business duration (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_duration (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Business duration (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_duration (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Business duration
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_duration]
Data Type: datetime
Aggregation: Year
Dimension: Business service (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_service (Request)]
Data Type: string
Aggregation: Count
Dimension: Business service (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_service (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Business service
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_service]
Data Type: string
Aggregation: Count
Dimension: Duration (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[calendar_duration (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Duration (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[calendar_duration (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Duration
Role: Discrete Dimension
Remote Column: [sqlproxy].[calendar_duration]
Data Type: datetime
Aggregation: Year
Dimension: Item
Role: Discrete Dimension
Remote Column: [sqlproxy].[cat_item]
Data Type: string
Aggregation: Count
Dimension: Category
Role: Discrete Dimension
Remote Column: [sqlproxy].[category]
Data Type: string
Aggregation: Count
Dimension: Close notes (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[close_notes (Request)]
Data Type: string
Aggregation: Count
Dimension: Close notes (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[close_notes (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Close notes
Role: Discrete Dimension
Remote Column: [sqlproxy].[close_notes]
Data Type: string
Aggregation: Count
Dimension: Closed (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_at (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Closed (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_at (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Closed
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_at]
Data Type: datetime
Aggregation: Year
Dimension: Closed by (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_by (Request)]
Data Type: string
Aggregation: Count
Dimension: Closed by (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_by (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Closed by
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_by]
Data Type: string
Aggregation: Count
Dimension: Configuration item (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[cmdb_ci (Request)]
Data Type: string
Aggregation: Count
Dimension: Configuration item (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[cmdb_ci (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Configuration item
Role: Discrete Dimension
Remote Column: [sqlproxy].[cmdb_ci]
Data Type: string
Aggregation: Count
Dimension: Additional comments (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments (Request)]
Data Type: string
Aggregation: Count
Dimension: Additional comments (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Additional comments
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments]
Data Type: string
Aggregation: Count
Dimension: Comments and Work notes (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments_and_work_notes (Request)]
Data Type: string
Aggregation: Count
Dimension: Comments and Work notes (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments_and_work_notes (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Comments and Work notes
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments_and_work_notes]
Data Type: string
Aggregation: Count
Dimension: Company (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[company (Request)]
Data Type: string
Aggregation: Count
Dimension: Company (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[company (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Company
Role: Discrete Dimension
Remote Column: [sqlproxy].[company]
Data Type: string
Aggregation: Count
Dimension: Configuration item (Requested Item) 1
Role: Discrete Dimension
Remote Column: [sqlproxy].[configuration_item]
Data Type: string
Aggregation: Count
Dimension: Contact type (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[contact_type (Request)]
Data Type: string
Aggregation: Count
Dimension: Contact type (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[contact_type (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Contact type
Role: Discrete Dimension
Remote Column: [sqlproxy].[contact_type]
Data Type: string
Aggregation: Count
Dimension: Context
Role: Discrete Dimension
Remote Column: [sqlproxy].[context]
Data Type: string
Aggregation: Count
Dimension: Correlation display (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_display (Request)]
Data Type: string
Aggregation: Count
Dimension: Correlation display (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_display (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Correlation display
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_display]
Data Type: string
Aggregation: Count
Dimension: Correlation ID (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_id (Request)]
Data Type: string
Aggregation: Count
Dimension: Correlation ID (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_id (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Correlation ID
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_id]
Data Type: string
Aggregation: Count
Dimension: Cart
Role: Discrete Dimension
Remote Column: [sqlproxy].[custom_cart]
Data Type: string
Aggregation: Count
Dimension: Delivery address
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_address]
Data Type: string
Aggregation: Count
Dimension: Execution Plan
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_plan (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Delivery plan (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_plan (Request)]
Data Type: string
Aggregation: Count
Dimension: Delivery plan (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_plan (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Delivery plan
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_plan]
Data Type: string
Aggregation: Count
Dimension: Delivery plan script
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_plan_script]
Data Type: string
Aggregation: Count
Dimension: Delivery task (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_task (Request)]
Data Type: string
Aggregation: Count
Dimension: Delivery task (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_task (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Delivery task
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_task]
Data Type: string
Aggregation: Count
Dimension: Delivery time
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_time]
Data Type: datetime
Aggregation: Year
Dimension: Description (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[description (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Description (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[description (Request)]
Data Type: string
Aggregation: Count
Dimension: Description (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[description (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Description
Role: Discrete Dimension
Remote Column: [sqlproxy].[description]
Data Type: string
Aggregation: Count
Dimension: Due date (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[due_date (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Due date (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[due_date (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Due date
Role: Discrete Dimension
Remote Column: [sqlproxy].[due_date]
Data Type: datetime
Aggregation: Year
Dimension: Entitlement script
Role: Discrete Dimension
Remote Column: [sqlproxy].[entitlement_script]
Data Type: string
Aggregation: Count
Dimension: Estimated Delivery
Role: Discrete Dimension
Remote Column: [sqlproxy].[estimated_delivery]
Data Type: datetime
Aggregation: Year
Dimension: Expected start (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[expected_start (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Expected start (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[expected_start (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Expected start
Role: Discrete Dimension
Remote Column: [sqlproxy].[expected_start]
Data Type: datetime
Aggregation: Year
Dimension: Follow up (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[follow_up (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Follow up (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[follow_up (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Follow up
Role: Discrete Dimension
Remote Column: [sqlproxy].[follow_up]
Data Type: datetime
Aggregation: Year
Dimension: Fulfillment group
Role: Discrete Dimension
Remote Column: [sqlproxy].[group]
Data Type: string
Aggregation: Count
Dimension: Group list (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[group_list (Request)]
Data Type: string
Aggregation: Count
Dimension: Group list (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[group_list (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Group list
Role: Discrete Dimension
Remote Column: [sqlproxy].[group_list]
Data Type: string
Aggregation: Count
Dimension: Icon
Role: Discrete Dimension
Remote Column: [sqlproxy].[icon]
Data Type: string
Aggregation: Count
Dimension: Ignore price
Role: Discrete Dimension
Remote Column: [sqlproxy].[ignore_price]
Data Type: boolean
Aggregation: Count
Dimension: Image
Role: Discrete Dimension
Remote Column: [sqlproxy].[image]
Data Type: string
Aggregation: Count
Dimension: Knowledge (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[knowledge (Request)]
Data Type: boolean
Aggregation: Count
Dimension: Knowledge (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[knowledge (Requested Item)]
Data Type: boolean
Aggregation: Count
Dimension: Knowledge
Role: Discrete Dimension
Remote Column: [sqlproxy].[knowledge]
Data Type: boolean
Aggregation: Count
Dimension: List Price
Role: Discrete Dimension
Remote Column: [sqlproxy].[list_price]
Data Type: string
Aggregation: Count
Dimension: Location (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[location (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Location (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[location (Request)]
Data Type: string
Aggregation: Count
Dimension: Location (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[location (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Location
Role: Discrete Dimension
Remote Column: [sqlproxy].[location]
Data Type: string
Aggregation: Count
Dimension: Made SLA (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[made_sla (Request)]
Data Type: boolean
Aggregation: Count
Dimension: Made SLA (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[made_sla (Requested Item)]
Data Type: boolean
Aggregation: Count
Dimension: Made SLA
Role: Discrete Dimension
Remote Column: [sqlproxy].[made_sla]
Data Type: boolean
Aggregation: Count
Dimension: Meta
Role: Discrete Dimension
Remote Column: [sqlproxy].[meta]
Data Type: string
Aggregation: Count
Dimension: Hide price (mobile listings)
Role: Discrete Dimension
Remote Column: [sqlproxy].[mobile_hide_price]
Data Type: boolean
Aggregation: Count
Dimension: Mobile Picture
Role: Discrete Dimension
Remote Column: [sqlproxy].[mobile_picture]
Data Type: string
Aggregation: Count
Dimension: Mobile Picture Type
Role: Discrete Dimension
Remote Column: [sqlproxy].[mobile_picture_type]
Data Type: string
Aggregation: Count
Dimension: Model
Role: Discrete Dimension
Remote Column: [sqlproxy].[model]
Data Type: string
Aggregation: Count
Dimension: Name
Role: Discrete Dimension
Remote Column: [sqlproxy].[name]
Data Type: string
Aggregation: Count
Dimension: No cart
Role: Discrete Dimension
Remote Column: [sqlproxy].[no_cart]
Data Type: boolean
Aggregation: Count
Dimension: No order
Role: Discrete Dimension
Remote Column: [sqlproxy].[no_order]
Data Type: boolean
Aggregation: Count
Dimension: No order now
Role: Discrete Dimension
Remote Column: [sqlproxy].[no_order_now]
Data Type: boolean
Aggregation: Count
Dimension: No proceed checkout
Role: Discrete Dimension
Remote Column: [sqlproxy].[no_proceed_checkout]
Data Type: boolean
Aggregation: Count
Dimension: No quantity
Role: Discrete Dimension
Remote Column: [sqlproxy].[no_quantity]
Data Type: boolean
Aggregation: Count
Dimension: No search
Role: Discrete Dimension
Remote Column: [sqlproxy].[no_search]
Data Type: boolean
Aggregation: Count
Dimension: Number (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[number (Request)]
Data Type: string
Aggregation: Count
Dimension: Number (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[number (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Number
Role: Discrete Dimension
Remote Column: [sqlproxy].[number]
Data Type: string
Aggregation: Count
Dimension: Omit price in cart
Role: Discrete Dimension
Remote Column: [sqlproxy].[omit_price]
Data Type: boolean
Aggregation: Count
Dimension: Opened (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_at (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Opened (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_at (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Opened
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_at]
Data Type: datetime
Aggregation: Year
Dimension: Opened by (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_by (Request)]
Data Type: string
Aggregation: Count
Dimension: Opened by (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_by (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Opened by
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_by]
Data Type: string
Aggregation: Count
Dimension: Order Guide
Role: Discrete Dimension
Remote Column: [sqlproxy].[order_guide]
Data Type: string
Aggregation: Count
Dimension: Ordered item link
Role: Discrete Dimension
Remote Column: [sqlproxy].[ordered_item_link]
Data Type: string
Aggregation: Count
Dimension: Parent (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[parent (Request)]
Data Type: string
Aggregation: Count
Dimension: Parent (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[parent (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Parent
Role: Discrete Dimension
Remote Column: [sqlproxy].[parent]
Data Type: string
Aggregation: Count
Dimension: Picture
Role: Discrete Dimension
Remote Column: [sqlproxy].[picture]
Data Type: string
Aggregation: Count
Dimension: Preview link
Role: Discrete Dimension
Remote Column: [sqlproxy].[preview]
Data Type: string
Aggregation: Count
Dimension: Price (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[price (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Price (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[price (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Price
Role: Discrete Dimension
Remote Column: [sqlproxy].[price]
Data Type: string
Aggregation: Count
Dimension: Priority
Role: Discrete Dimension
Remote Column: [sqlproxy].[priority]
Data Type: integer
Aggregation: Sum
Dimension: Recurring Price Frequency (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[recurring_frequency (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Recurring Price Frequency
Role: Discrete Dimension
Remote Column: [sqlproxy].[recurring_frequency]
Data Type: string
Aggregation: Count
Dimension: Recurring price
Role: Discrete Dimension
Remote Column: [sqlproxy].[recurring_price (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Recurring Price
Role: Discrete Dimension
Remote Column: [sqlproxy].[recurring_price]
Data Type: string
Aggregation: Count
Dimension: Request
Role: Discrete Dimension
Remote Column: [sqlproxy].[request]
Data Type: string
Aggregation: Count
Dimension: Request state
Role: Discrete Dimension
Remote Column: [sqlproxy].[request_state]
Data Type: string
Aggregation: Count
Dimension: Requested for date
Role: Discrete Dimension
Remote Column: [sqlproxy].[requested_date]
Data Type: date
Aggregation: Year
Dimension: Requested for
Role: Discrete Dimension
Remote Column: [sqlproxy].[requested_for]
Data Type: string
Aggregation: Count
Dimension: Roles
Role: Discrete Dimension
Remote Column: [sqlproxy].[roles]
Data Type: string
Aggregation: Count
Dimension: Catalog
Role: Discrete Dimension
Remote Column: [sqlproxy].[sc_catalog]
Data Type: string
Aggregation: Count
Dimension: Catalogs
Role: Discrete Dimension
Remote Column: [sqlproxy].[sc_catalogs]
Data Type: string
Aggregation: Count
Dimension: Created from item design
Role: Discrete Dimension
Remote Column: [sqlproxy].[sc_ic_item_staging]
Data Type: string
Aggregation: Count
Dimension: Short description (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[short_description (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Short description (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[short_description (Request)]
Data Type: string
Aggregation: Count
Dimension: Short description (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[short_description (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Short description
Role: Discrete Dimension
Remote Column: [sqlproxy].[short_description]
Data Type: string
Aggregation: Count
Dimension: SLA due (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sla_due (Request)]
Data Type: datetime
Aggregation: Year
Dimension: SLA due (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sla_due (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: SLA due
Role: Discrete Dimension
Remote Column: [sqlproxy].[sla_due]
Data Type: datetime
Aggregation: Year
Dimension: Special instructions
Role: Discrete Dimension
Remote Column: [sqlproxy].[special_instructions]
Data Type: string
Aggregation: Count
Dimension: Stage (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[stage (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Stage
Role: Discrete Dimension
Remote Column: [sqlproxy].[stage]
Data Type: string
Aggregation: Count
Dimension: Start closed
Role: Discrete Dimension
Remote Column: [sqlproxy].[start_closed]
Data Type: boolean
Aggregation: Count
Dimension: Class
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_class_name (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Task type (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_class_name (Request)]
Data Type: string
Aggregation: Count
Dimension: Task type (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_class_name (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Task type
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_class_name]
Data Type: string
Aggregation: Count
Dimension: Created by (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_by (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Created by (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_by (Request)]
Data Type: string
Aggregation: Count
Dimension: Created by (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_by (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Created by
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_by]
Data Type: string
Aggregation: Count
Dimension: Created (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_on (Catalog Item)]
Data Type: datetime
Aggregation: Year
Dimension: Created (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_on (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Created (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_on (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Created
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_on]
Data Type: datetime
Aggregation: Year
Dimension: Customer update
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_customer_update]
Data Type: boolean
Aggregation: Count
Dimension: Domain (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain (Request)]
Data Type: string
Aggregation: Count
Dimension: Domain (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Domain
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain]
Data Type: string
Aggregation: Count
Dimension: Domain Path (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain_path (Request)]
Data Type: string
Aggregation: Count
Dimension: Domain Path (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain_path (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Domain Path
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain_path]
Data Type: string
Aggregation: Count
Dimension: Sys ID (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_id (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Sys ID (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_id (Request)]
Data Type: string
Aggregation: Count
Dimension: Sys ID (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_id (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Sys ID
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_id]
Data Type: string
Aggregation: Count
Dimension: Display name
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_name]
Data Type: string
Aggregation: Count
Dimension: Package
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_package]
Data Type: string
Aggregation: Count
Dimension: Protection policy
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_policy]
Data Type: string
Aggregation: Count
Dimension: Replace on upgrade
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_replace_on_upgrade]
Data Type: boolean
Aggregation: Count
Dimension: Application
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_scope]
Data Type: string
Aggregation: Count
Dimension: Update name
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_update_name]
Data Type: string
Aggregation: Count
Dimension: Updated by (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_by (Catalog Item)]
Data Type: string
Aggregation: Count
Dimension: Updated by (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_by (Request)]
Data Type: string
Aggregation: Count
Dimension: Updated by (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_by (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Updated by
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_by]
Data Type: string
Aggregation: Count
Dimension: Updated (Catalog Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_on (Catalog Item)]
Data Type: datetime
Aggregation: Year
Dimension: Updated (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_on (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Updated (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_on (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Updated
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_on]
Data Type: datetime
Aggregation: Year
Dimension: Template
Role: Discrete Dimension
Remote Column: [sqlproxy].[template]
Data Type: string
Aggregation: Count
Dimension: Time worked (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[time_worked (Request)]
Data Type: string
Aggregation: Count
Dimension: Time worked (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[time_worked (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Time worked
Role: Discrete Dimension
Remote Column: [sqlproxy].[time_worked]
Data Type: string
Aggregation: Count
Dimension: Type
Role: Discrete Dimension
Remote Column: [sqlproxy].[type]
Data Type: string
Aggregation: Count
Dimension: Upon approval (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_approval (Request)]
Data Type: string
Aggregation: Count
Dimension: Upon approval (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_approval (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Upon approval
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_approval]
Data Type: string
Aggregation: Count
Dimension: Upon reject (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_reject (Request)]
Data Type: string
Aggregation: Count
Dimension: Upon reject (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_reject (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Upon reject
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_reject]
Data Type: string
Aggregation: Count
Dimension: Use cart layout
Role: Discrete Dimension
Remote Column: [sqlproxy].[use_sc_layout]
Data Type: boolean
Aggregation: Count
Dimension: User input (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[user_input (Request)]
Data Type: string
Aggregation: Count
Dimension: User input (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[user_input (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: User input
Role: Discrete Dimension
Remote Column: [sqlproxy].[user_input]
Data Type: string
Aggregation: Count
Dimension: Vendor
Role: Discrete Dimension
Remote Column: [sqlproxy].[vendor]
Data Type: string
Aggregation: Count
Dimension: Visible on Bundles
Role: Discrete Dimension
Remote Column: [sqlproxy].[visible_bundle]
Data Type: boolean
Aggregation: Count
Dimension: Visible on Guides
Role: Discrete Dimension
Remote Column: [sqlproxy].[visible_guide]
Data Type: boolean
Aggregation: Count
Dimension: Visible elsewhere
Role: Discrete Dimension
Remote Column: [sqlproxy].[visible_standalone]
Data Type: boolean
Aggregation: Count
Dimension: Watch list (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[watch_list (Request)]
Data Type: string
Aggregation: Count
Dimension: Watch list (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[watch_list (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Watch list
Role: Discrete Dimension
Remote Column: [sqlproxy].[watch_list]
Data Type: string
Aggregation: Count
Dimension: Work end (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_end (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Work end (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_end (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Work end
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_end]
Data Type: datetime
Aggregation: Year
Dimension: Work notes (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes (Request)]
Data Type: string
Aggregation: Count
Dimension: Work notes (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Work notes
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes]
Data Type: string
Aggregation: Count
Dimension: Work notes list (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes_list (Request)]
Data Type: string
Aggregation: Count
Dimension: Work notes list (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes_list (Requested Item)]
Data Type: string
Aggregation: Count
Dimension: Work notes list
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes_list]
Data Type: string
Aggregation: Count
Dimension: Work start (Request)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_start (Request)]
Data Type: datetime
Aggregation: Year
Dimension: Work start (Requested Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_start (Requested Item)]
Data Type: datetime
Aggregation: Year
Dimension: Work start
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_start]
Data Type: datetime
Aggregation: Year
Dimension: Workflow
Role: Discrete Dimension
Remote Column: [sqlproxy].[workflow]
Data Type: string
Aggregation: Count
Calculated/Other
Dimension: Measure Names
Role: Discrete Dimension
Data Type: string
Aggregation: Count
Measure
sqlproxy
Measure: % made SLA
Role: Continous Measure
Remote Column: [sqlproxy].[Calculation_217580207412346890]
Data Type: real
Formula: // This is a calculated field
// It shows the percentage of requests which made SLA
COUNTD(IF [made_sla]= TRUE
THEN [number]
END)
/
COUNTD([number])
Aggregation: User
Measure: Current Year Total Cases
Role: Continous Measure
Remote Column: [sqlproxy].[Calculation_466404086152966145]
Data Type: integer
Formula: // This is a calculated field
// It counts each distinct request made in the last year. The "exclude" is used to avoid filters interfering in the final result
{EXCLUDE [opened_at], [Overdue], [Max Year?]:
COUNTD(IF [Max Year?]=TRUE
THEN [number]
END)
}
Aggregation: Attribute
Measure: Total # Request
Role: Continous Measure
Remote Column: [sqlproxy].[Calculation_466404086465376264]
Data Type: integer
Formula: // This is a calculated field
// It shows the total number of problems ignoring opened date
{ EXCLUDE [opened_at]: COUNTD([number])}
Aggregation: Attribute
Measure: Total Active Requests
Role: Continous Measure
Remote Column: [sqlproxy].[Current Year Total Cases (copy)]
Data Type: integer
Formula: // This is a calculated field
// It counts each distinct active request. The "exclude" is used to avoid filters interfering with the final result
{EXCLUDE [opened_at], [Overdue], [Max Year?]:
COUNTD(IF [active]=TRUE
THEN [number]
END)
}
Aggregation: Attribute
Measure: Resolve Time
Role: Continous Measure
Remote Column: [sqlproxy].[calendar_stc]
Data Type: integer
Aggregation: Sum
Measure: Cost
Role: Continous Measure
Remote Column: [sqlproxy].[cost]
Data Type: real
Aggregation: Sum
Measure: Escalation (Request)
Role: Continous Measure
Remote Column: [sqlproxy].[escalation (Request)]
Data Type: integer
Aggregation: Sum
Measure: Escalation (Requested Item)
Role: Continous Measure
Remote Column: [sqlproxy].[escalation (Requested Item)]
Data Type: integer
Aggregation: Sum
Measure: Escalation
Role: Continous Measure
Remote Column: [sqlproxy].[escalation]
Data Type: integer
Aggregation: Sum
Measure: Impact (Request)
Role: Continous Measure
Remote Column: [sqlproxy].[impact (Request)]
Data Type: integer
Aggregation: Sum
Measure: Impact (Requested Item)
Role: Continous Measure
Remote Column: [sqlproxy].[impact (Requested Item)]
Data Type: integer
Aggregation: Sum
Measure: Impact
Role: Continous Measure
Remote Column: [sqlproxy].[impact]
Data Type: integer
Aggregation: Sum
Measure: Order (Catalog Item)
Role: Continous Measure
Remote Column: [sqlproxy].[order (Catalog Item)]
Data Type: integer
Aggregation: Sum
Measure: Order (Request)
Role: Continous Measure
Remote Column: [sqlproxy].[order (Request)]
Data Type: integer
Aggregation: Sum
Measure: Order (Requested Item)
Role: Continous Measure
Remote Column: [sqlproxy].[order (Requested Item)]
Data Type: integer
Aggregation: Sum
Measure: Order
Role: Continous Measure
Remote Column: [sqlproxy].[order]
Data Type: integer
Aggregation: Sum
Measure: Priority (Request)
Role: Continous Measure
Remote Column: [sqlproxy].[priority (Request)]
Data Type: integer
Aggregation: Sum
Measure: Priority (Requested Item)
Role: Continous Measure
Remote Column: [sqlproxy].[priority (Requested Item)]
Data Type: integer
Aggregation: Sum
Measure: Quantity
Role: Continous Measure
Remote Column: [sqlproxy].[quantity]
Data Type: integer
Aggregation: Sum
Measure: Reassignment count (Request)
Role: Continous Measure
Remote Column: [sqlproxy].[reassignment_count (Request)]
Data Type: integer
Aggregation: Sum
Measure: Reassignment count (Requested Item)
Role: Continous Measure
Remote Column: [sqlproxy].[reassignment_count (Requested Item)]
Data Type: integer
Aggregation: Sum
Measure: Reassignment count
Role: Continous Measure
Remote Column: [sqlproxy].[reassignment_count]
Data Type: integer
Aggregation: Sum
Measure: Published version
Role: Continous Measure
Remote Column: [sqlproxy].[sc_ic_version]
Data Type: integer
Aggregation: Sum
Measure: State (Request)
Role: Continous Measure
Remote Column: [sqlproxy].[state (Request)]
Data Type: integer
Aggregation: Sum
Measure: State (Requested Item)
Role: Continous Measure
Remote Column: [sqlproxy].[state (Requested Item)]
Data Type: integer
Aggregation: Sum
Measure: State
Role: Continous Measure
Remote Column: [sqlproxy].[state]
Data Type: integer
Aggregation: Sum
Measure: Updates (Catalog Item)
Role: Continous Measure
Remote Column: [sqlproxy].[sys_mod_count (Catalog Item)]
Data Type: integer
Aggregation: Sum
Measure: Updates (Request)
Role: Continous Measure
Remote Column: [sqlproxy].[sys_mod_count (Request)]
Data Type: integer
Aggregation: Sum
Measure: Updates (Requested Item)
Role: Continous Measure
Remote Column: [sqlproxy].[sys_mod_count (Requested Item)]
Data Type: integer
Aggregation: Sum
Measure: Updates
Role: Continous Measure
Remote Column: [sqlproxy].[sys_mod_count]
Data Type: integer
Aggregation: Sum
Measure: Urgency (Request)
Role: Continous Measure
Remote Column: [sqlproxy].[urgency (Request)]
Data Type: integer
Aggregation: Sum
Measure: Urgency (Requested Item)
Role: Continous Measure
Remote Column: [sqlproxy].[urgency (Requested Item)]
Data Type: integer
Aggregation: Sum
Measure: Urgency
Role: Continous Measure
Remote Column: [sqlproxy].[urgency]
Data Type: integer
Aggregation: Sum
Measure: Number of Records
Role: Continous Measure
Remote Column: [sqlproxy].[Number of Records]
Data Type: integer
Aggregation: Sum
Calculated/Other
Measure: % of Overdue
Role: Continous Measure
Data Type: real
Formula: // This is a calculated field
// It shows the percentage of incidents which are overdue
(IF ATTR([Overdue]= "Overdue")
THEN COUNTD([number])
END)
/
ATTR({ EXCLUDE [Overdue]:
COUNTD([number])})
Aggregation: User
Measure: Measure Values
Role: Continous Measure
Data Type: real
Aggregation: Sum
Semantic Values
[Country].[Name]: "United States"
Datasource: Incidents
Connection
Data Sources
Data Source: Incidents
Attributes
channel: http
class: sqlproxy
dbname: Incidents
directory: /dataserver
port: 80
server: bnbrepository9
username: {"user":"","apiInstance":""}
workgroup-auth-mode: prompt
Tables
Table: sqlproxy
Database Object: [sqlproxy]
Connection: Incidents
Dimension
sqlproxy
Dimension: Overdue
Role: Discrete Dimension
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Data Type: string
Formula: // This is a calculated field
// It shows if an incident is overdue
//Check overdue cases among inactive incidents
{ FIXED [number]:
IF MAX([active]=FALSE)
AND
max([closed_at])>max([due_date])
OR
//Check overdue cases among active incidents
MAX([active] = TRUE)
AND NOW() > MAX([due_date])
THEN "Overdue"
END
}
Aggregation: Count
Dimension: Max Year?
Role: Discrete Dimension
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Data Type: boolean
Formula: // This is a calculated field
// It shows TRUE/FALSE if opened date equals maximum year in the dataset
DATEPART("year", [opened_at]) = DATEPART("year", {MAX([opened_at])})
Aggregation: Count
Dimension: Opened Month Tooltip
Role: Discrete Dimension
Remote Column: [sqlproxy].[Opened (copy)]
Data Type: string
Formula: // This is an IF statment using the opened field to allow for different formats
// original used on columns for line charts are formatted in starting letter of month i.e. J for January
// This version formats to full month name for the tooltip
// The IF statement names the month based on the month number of the datefield
IF DATEPART('month', [opened_at]) = 1 THEN 'January'
ELSEIF DATEPART('month', [opened_at]) = 2 THEN 'February'
ELSEIF DATEPART('month', [opened_at]) = 3 THEN 'March'
ELSEIF DATEPART('month', [opened_at]) = 4 THEN 'April'
ELSEIF DATEPART('month', [opened_at]) = 5 THEN 'May'
ELSEIF DATEPART('month', [opened_at]) = 6 THEN 'June'
ELSEIF DATEPART('month', [opened_at]) = 7 THEN 'July'
ELSEIF DATEPART('month', [opened_at]) = 8 THEN 'August'
ELSEIF DATEPART('month', [opened_at]) = 9 THEN 'September'
ELSEIF DATEPART('month', [opened_at]) = 10 THEN 'October'
ELSEIF DATEPART('month', [opened_at]) = 11 THEN 'Novemeber'
ELSEIF DATEPART('month', [opened_at]) = 12 THEN 'December'
ELSE NULL
END
Aggregation: Count
Dimension: Active (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[active (Incident)]
Data Type: boolean
Aggregation: Count
Dimension: Active
Role: Discrete Dimension
Remote Column: [sqlproxy].[active]
Data Type: boolean
Aggregation: Count
Dimension: Activity due (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[activity_due (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Activity due
Role: Discrete Dimension
Remote Column: [sqlproxy].[activity_due]
Data Type: datetime
Aggregation: Year
Dimension: Additional assignee list (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[additional_assignee_list (Incident)]
Data Type: string
Aggregation: Count
Dimension: Additional assignee list
Role: Discrete Dimension
Remote Column: [sqlproxy].[additional_assignee_list]
Data Type: string
Aggregation: Count
Dimension: Approval (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval (Incident)]
Data Type: string
Aggregation: Count
Dimension: Approval
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval]
Data Type: string
Aggregation: Count
Dimension: Approval history (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_history (Incident)]
Data Type: string
Aggregation: Count
Dimension: Approval history
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_history]
Data Type: string
Aggregation: Count
Dimension: Approval set (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_set (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Approval set
Role: Discrete Dimension
Remote Column: [sqlproxy].[approval_set]
Data Type: datetime
Aggregation: Year
Dimension: Asset
Role: Discrete Dimension
Remote Column: [sqlproxy].[asset]
Data Type: string
Aggregation: Count
Dimension: Asset tag
Role: Discrete Dimension
Remote Column: [sqlproxy].[asset_tag]
Data Type: string
Aggregation: Count
Dimension: Assigned
Role: Discrete Dimension
Remote Column: [sqlproxy].[assigned]
Data Type: datetime
Aggregation: Year
Dimension: Assigned to (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[assigned_to (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Assigned to (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[assigned_to (Incident)]
Data Type: string
Aggregation: Count
Dimension: Assigned to
Role: Discrete Dimension
Remote Column: [sqlproxy].[assigned_to]
Data Type: string
Aggregation: Count
Dimension: Assignment group (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[assignment_group (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Assignment group (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[assignment_group (Incident)]
Data Type: string
Aggregation: Count
Dimension: Assignment group
Role: Discrete Dimension
Remote Column: [sqlproxy].[assignment_group]
Data Type: string
Aggregation: Count
Dimension: Attributes
Role: Discrete Dimension
Remote Column: [sqlproxy].[attributes]
Data Type: string
Aggregation: Count
Dimension: Business duration (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_duration (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Business duration
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_duration]
Data Type: datetime
Aggregation: Year
Dimension: Business service (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_service (Incident)]
Data Type: string
Aggregation: Count
Dimension: Business service
Role: Discrete Dimension
Remote Column: [sqlproxy].[business_service]
Data Type: string
Aggregation: Count
Dimension: Duration (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[calendar_duration (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Duration
Role: Discrete Dimension
Remote Column: [sqlproxy].[calendar_duration]
Data Type: datetime
Aggregation: Year
Dimension: Caller (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[caller_id (Incident)]
Data Type: string
Aggregation: Count
Dimension: Can Print
Role: Discrete Dimension
Remote Column: [sqlproxy].[can_print]
Data Type: boolean
Aggregation: Count
Dimension: Category (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[category (Incident)]
Data Type: string
Aggregation: Count
Dimension: Category (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[category]
Data Type: string
Aggregation: Count
Dimension: Caused by Change (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[caused_by (Incident)]
Data Type: string
Aggregation: Count
Dimension: Approval group
Role: Discrete Dimension
Remote Column: [sqlproxy].[change_control]
Data Type: string
Aggregation: Count
Dimension: Checked in
Role: Discrete Dimension
Remote Column: [sqlproxy].[checked_in]
Data Type: datetime
Aggregation: Year
Dimension: Checked out
Role: Discrete Dimension
Remote Column: [sqlproxy].[checked_out]
Data Type: datetime
Aggregation: Year
Dimension: Close code (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[close_code (Incident)]
Data Type: string
Aggregation: Count
Dimension: Close notes (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[close_notes (Incident)]
Data Type: string
Aggregation: Count
Dimension: Close notes
Role: Discrete Dimension
Remote Column: [sqlproxy].[close_notes]
Data Type: string
Aggregation: Count
Dimension: Closed (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_at (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Closed
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_at]
Data Type: datetime
Aggregation: Year
Dimension: Closed by (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_by (Incident)]
Data Type: string
Aggregation: Count
Dimension: Closed by
Role: Discrete Dimension
Remote Column: [sqlproxy].[closed_by]
Data Type: string
Aggregation: Count
Dimension: Configuration item (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[cmdb_ci (Incident)]
Data Type: string
Aggregation: Count
Dimension: Configuration item
Role: Discrete Dimension
Remote Column: [sqlproxy].[cmdb_ci]
Data Type: string
Aggregation: Count
Dimension: Comments
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Additional comments (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments (Incident)]
Data Type: string
Aggregation: Count
Dimension: Additional comments
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments]
Data Type: string
Aggregation: Count
Dimension: Comments and Work notes (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments_and_work_notes (Incident)]
Data Type: string
Aggregation: Count
Dimension: Comments and Work notes
Role: Discrete Dimension
Remote Column: [sqlproxy].[comments_and_work_notes]
Data Type: string
Aggregation: Count
Dimension: Company (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[company (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Company (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[company (Incident)]
Data Type: string
Aggregation: Count
Dimension: Company
Role: Discrete Dimension
Remote Column: [sqlproxy].[company]
Data Type: string
Aggregation: Count
Dimension: Contact type (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[contact_type (Incident)]
Data Type: string
Aggregation: Count
Dimension: Contact type
Role: Discrete Dimension
Remote Column: [sqlproxy].[contact_type]
Data Type: string
Aggregation: Count
Dimension: Correlation display (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_display (Incident)]
Data Type: string
Aggregation: Count
Dimension: Correlation display
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_display]
Data Type: string
Aggregation: Count
Dimension: Correlation ID (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_id (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Correlation ID (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_id (Incident)]
Data Type: string
Aggregation: Count
Dimension: Correlation ID
Role: Discrete Dimension
Remote Column: [sqlproxy].[correlation_id]
Data Type: string
Aggregation: Count
Dimension: Cost
Role: Discrete Dimension
Remote Column: [sqlproxy].[cost]
Data Type: string
Aggregation: Count
Dimension: Cost currency
Role: Discrete Dimension
Remote Column: [sqlproxy].[cost_cc]
Data Type: string
Aggregation: Count
Dimension: Cost center
Role: Discrete Dimension
Remote Column: [sqlproxy].[cost_center]
Data Type: string
Aggregation: Count
Dimension: Order received
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_date]
Data Type: datetime
Aggregation: Year
Dimension: Delivery plan (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_plan (Incident)]
Data Type: string
Aggregation: Count
Dimension: Delivery plan
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_plan]
Data Type: string
Aggregation: Count
Dimension: Delivery task (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_task (Incident)]
Data Type: string
Aggregation: Count
Dimension: Delivery task
Role: Discrete Dimension
Remote Column: [sqlproxy].[delivery_task]
Data Type: string
Aggregation: Count
Dimension: Department
Role: Discrete Dimension
Remote Column: [sqlproxy].[department]
Data Type: string
Aggregation: Count
Dimension: Description (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[description (Incident)]
Data Type: string
Aggregation: Count
Dimension: Description
Role: Discrete Dimension
Remote Column: [sqlproxy].[description]
Data Type: string
Aggregation: Count
Dimension: Discovery source
Role: Discrete Dimension
Remote Column: [sqlproxy].[discovery_source]
Data Type: string
Aggregation: Count
Dimension: DNS Domain
Role: Discrete Dimension
Remote Column: [sqlproxy].[dns_domain]
Data Type: string
Aggregation: Count
Dimension: Due
Role: Discrete Dimension
Remote Column: [sqlproxy].[due]
Data Type: datetime
Aggregation: Year
Dimension: Due date (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[due_date (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Due date
Role: Discrete Dimension
Remote Column: [sqlproxy].[due_date]
Data Type: datetime
Aggregation: Year
Dimension: Due in
Role: Discrete Dimension
Remote Column: [sqlproxy].[due_in]
Data Type: string
Aggregation: Count
Dimension: Expected start (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[expected_start (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Expected start
Role: Discrete Dimension
Remote Column: [sqlproxy].[expected_start]
Data Type: datetime
Aggregation: Year
Dimension: First discovered
Role: Discrete Dimension
Remote Column: [sqlproxy].[first_discovered]
Data Type: datetime
Aggregation: Year
Dimension: Follow up (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[follow_up (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Follow up
Role: Discrete Dimension
Remote Column: [sqlproxy].[follow_up]
Data Type: datetime
Aggregation: Year
Dimension: Fully qualified domain name
Role: Discrete Dimension
Remote Column: [sqlproxy].[fqdn]
Data Type: string
Aggregation: Count
Dimension: GL account
Role: Discrete Dimension
Remote Column: [sqlproxy].[gl_account]
Data Type: string
Aggregation: Count
Dimension: Group list (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[group_list (Incident)]
Data Type: string
Aggregation: Count
Dimension: Group list
Role: Discrete Dimension
Remote Column: [sqlproxy].[group_list]
Data Type: string
Aggregation: Count
Dimension: Installed
Role: Discrete Dimension
Remote Column: [sqlproxy].[install_date]
Data Type: datetime
Aggregation: Year
Dimension: Invoice number
Role: Discrete Dimension
Remote Column: [sqlproxy].[invoice_number]
Data Type: string
Aggregation: Count
Dimension: IP Address
Role: Discrete Dimension
Remote Column: [sqlproxy].[ip_address]
Data Type: string
Aggregation: Count
Dimension: Justification
Role: Discrete Dimension
Remote Column: [sqlproxy].[justification]
Data Type: string
Aggregation: Count
Dimension: Knowledge (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[knowledge (Incident)]
Data Type: boolean
Aggregation: Count
Dimension: Knowledge
Role: Discrete Dimension
Remote Column: [sqlproxy].[knowledge]
Data Type: boolean
Aggregation: Count
Dimension: Most recent discovery
Role: Discrete Dimension
Remote Column: [sqlproxy].[last_discovered]
Data Type: datetime
Aggregation: Year
Dimension: Lease contract
Role: Discrete Dimension
Remote Column: [sqlproxy].[lease_id]
Data Type: string
Aggregation: Count
Dimension: Location (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[location (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Location (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[location (Incident)]
Data Type: string
Aggregation: Count
Dimension: Location
Role: Discrete Dimension
Remote Column: [sqlproxy].[location]
Data Type: string
Aggregation: Count
Dimension: MAC Address
Role: Discrete Dimension
Remote Column: [sqlproxy].[mac_address]
Data Type: string
Aggregation: Count
Dimension: Made SLA (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[made_sla (Incident)]
Data Type: boolean
Aggregation: Count
Dimension: Made SLA
Role: Discrete Dimension
Remote Column: [sqlproxy].[made_sla]
Data Type: boolean
Aggregation: Count
Dimension: Maintenance schedule
Role: Discrete Dimension
Remote Column: [sqlproxy].[maintenance_schedule]
Data Type: string
Aggregation: Count
Dimension: Managed by
Role: Discrete Dimension
Remote Column: [sqlproxy].[managed_by]
Data Type: string
Aggregation: Count
Dimension: Manufacturer
Role: Discrete Dimension
Remote Column: [sqlproxy].[manufacturer]
Data Type: string
Aggregation: Count
Dimension: Model ID
Role: Discrete Dimension
Remote Column: [sqlproxy].[model_id]
Data Type: string
Aggregation: Count
Dimension: Model number
Role: Discrete Dimension
Remote Column: [sqlproxy].[model_number]
Data Type: string
Aggregation: Count
Dimension: Monitor
Role: Discrete Dimension
Remote Column: [sqlproxy].[monitor]
Data Type: boolean
Aggregation: Count
Dimension: Name
Role: Discrete Dimension
Remote Column: [sqlproxy].[name]
Data Type: string
Aggregation: Count
Dimension: Number (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[number (Incident)]
Data Type: string
Aggregation: Count
Dimension: Number
Role: Discrete Dimension
Remote Column: [sqlproxy].[number]
Data Type: string
Aggregation: Count
Dimension: Opened (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_at (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Opened
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_at]
Data Type: datetime
Aggregation: Year
Dimension: Opened by (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_by (Incident)]
Data Type: string
Aggregation: Count
Dimension: Opened by
Role: Discrete Dimension
Remote Column: [sqlproxy].[opened_by]
Data Type: string
Aggregation: Count
Dimension: Ordered
Role: Discrete Dimension
Remote Column: [sqlproxy].[order_date]
Data Type: datetime
Aggregation: Year
Dimension: Owned by
Role: Discrete Dimension
Remote Column: [sqlproxy].[owned_by]
Data Type: string
Aggregation: Count
Dimension: Parent (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[parent (Incident)]
Data Type: string
Aggregation: Count
Dimension: Parent
Role: Discrete Dimension
Remote Column: [sqlproxy].[parent]
Data Type: string
Aggregation: Count
Dimension: Parent Incident (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[parent_incident (Incident)]
Data Type: string
Aggregation: Count
Dimension: PO number
Role: Discrete Dimension
Remote Column: [sqlproxy].[po_number]
Data Type: string
Aggregation: Count
Dimension: Priority
Role: Discrete Dimension
Remote Column: [sqlproxy].[priority]
Data Type: integer
Aggregation: Sum
Dimension: Problem (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[problem_id (Incident)]
Data Type: string
Aggregation: Count
Dimension: Purchased
Role: Discrete Dimension
Remote Column: [sqlproxy].[purchase_date]
Data Type: date
Aggregation: Year
Dimension: Resolved (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[resolved_at (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Resolved by (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[resolved_by (Incident)]
Data Type: string
Aggregation: Count
Dimension: Change Request (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[rfc (Incident)]
Data Type: string
Aggregation: Count
Dimension: Schedule
Role: Discrete Dimension
Remote Column: [sqlproxy].[schedule]
Data Type: string
Aggregation: Count
Dimension: Serial number
Role: Discrete Dimension
Remote Column: [sqlproxy].[serial_number]
Data Type: string
Aggregation: Count
Dimension: Description (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[short_description (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Short description (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[short_description (Incident)]
Data Type: string
Aggregation: Count
Dimension: Short description
Role: Discrete Dimension
Remote Column: [sqlproxy].[short_description]
Data Type: string
Aggregation: Count
Dimension: Skip sync
Role: Discrete Dimension
Remote Column: [sqlproxy].[skip_sync]
Data Type: boolean
Aggregation: Count
Dimension: SLA due (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sla_due (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: SLA due
Role: Discrete Dimension
Remote Column: [sqlproxy].[sla_due]
Data Type: datetime
Aggregation: Year
Dimension: Start date
Role: Discrete Dimension
Remote Column: [sqlproxy].[start_date]
Data Type: datetime
Aggregation: Year
Dimension: Subcategory (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[subcategory (Incident)]
Data Type: string
Aggregation: Count
Dimension: Subcategory (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[subcategory]
Data Type: string
Aggregation: Count
Dimension: Support group
Role: Discrete Dimension
Remote Column: [sqlproxy].[support_group]
Data Type: string
Aggregation: Count
Dimension: Supported by
Role: Discrete Dimension
Remote Column: [sqlproxy].[supported_by]
Data Type: string
Aggregation: Count
Dimension: Class
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_class_name (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Task type (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_class_name (Incident)]
Data Type: string
Aggregation: Count
Dimension: Task type
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_class_name]
Data Type: string
Aggregation: Count
Dimension: Created by (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_by (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Created by (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_by (Incident)]
Data Type: string
Aggregation: Count
Dimension: Created by
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_by]
Data Type: string
Aggregation: Count
Dimension: Created (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_on (Configuration Item)]
Data Type: datetime
Aggregation: Year
Dimension: Created (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_on (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Created
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_created_on]
Data Type: datetime
Aggregation: Year
Dimension: Domain (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Domain (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain (Incident)]
Data Type: string
Aggregation: Count
Dimension: Domain
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain]
Data Type: string
Aggregation: Count
Dimension: Domain Path (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain_path (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Domain Path (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain_path (Incident)]
Data Type: string
Aggregation: Count
Dimension: Domain Path
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_domain_path]
Data Type: string
Aggregation: Count
Dimension: Sys ID (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_id (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Sys ID (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_id (Incident)]
Data Type: string
Aggregation: Count
Dimension: Sys ID
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_id]
Data Type: string
Aggregation: Count
Dimension: Updated by (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_by (Configuration Item)]
Data Type: string
Aggregation: Count
Dimension: Updated by (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_by (Incident)]
Data Type: string
Aggregation: Count
Dimension: Updated by
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_by]
Data Type: string
Aggregation: Count
Dimension: Updated (Configuration Item)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_on (Configuration Item)]
Data Type: datetime
Aggregation: Year
Dimension: Updated (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_on (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Updated
Role: Discrete Dimension
Remote Column: [sqlproxy].[sys_updated_on]
Data Type: datetime
Aggregation: Year
Dimension: Time worked (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[time_worked (Incident)]
Data Type: string
Aggregation: Count
Dimension: Time worked
Role: Discrete Dimension
Remote Column: [sqlproxy].[time_worked]
Data Type: string
Aggregation: Count
Dimension: Requires verification
Role: Discrete Dimension
Remote Column: [sqlproxy].[unverified]
Data Type: boolean
Aggregation: Count
Dimension: Upon approval (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_approval (Incident)]
Data Type: string
Aggregation: Count
Dimension: Upon approval
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_approval]
Data Type: string
Aggregation: Count
Dimension: Upon reject (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_reject (Incident)]
Data Type: string
Aggregation: Count
Dimension: Upon reject
Role: Discrete Dimension
Remote Column: [sqlproxy].[upon_reject]
Data Type: string
Aggregation: Count
Dimension: User input (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[user_input (Incident)]
Data Type: string
Aggregation: Count
Dimension: User input
Role: Discrete Dimension
Remote Column: [sqlproxy].[user_input]
Data Type: string
Aggregation: Count
Dimension: Vendor
Role: Discrete Dimension
Remote Column: [sqlproxy].[vendor]
Data Type: string
Aggregation: Count
Dimension: Warranty expiration
Role: Discrete Dimension
Remote Column: [sqlproxy].[warranty_expiration]
Data Type: date
Aggregation: Year
Dimension: Watch list (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[watch_list (Incident)]
Data Type: string
Aggregation: Count
Dimension: Watch list
Role: Discrete Dimension
Remote Column: [sqlproxy].[watch_list]
Data Type: string
Aggregation: Count
Dimension: Work end (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_end (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Work end
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_end]
Data Type: datetime
Aggregation: Year
Dimension: Work notes (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes (Incident)]
Data Type: string
Aggregation: Count
Dimension: Work notes
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes]
Data Type: string
Aggregation: Count
Dimension: Work notes list (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes_list (Incident)]
Data Type: string
Aggregation: Count
Dimension: Work notes list
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_notes_list]
Data Type: string
Aggregation: Count
Dimension: Work start (Incident)
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_start (Incident)]
Data Type: datetime
Aggregation: Year
Dimension: Work start
Role: Discrete Dimension
Remote Column: [sqlproxy].[work_start]
Data Type: datetime
Aggregation: Year
Calculated/Other
Dimension: Measure Names
Role: Discrete Dimension
Data Type: string
Aggregation: Count
Measure
sqlproxy
Measure: Current Year Total Cases
Role: Continous Measure
Remote Column: [sqlproxy].[Calculation_466404086152966145]
Data Type: integer
Formula: // This is a calculated field using level of detail calculation
// It counts each distinct incident. The exclude is used to guarantee that filters will not interfere in the result
{EXCLUDE [opened_at], [Overdue], [Max Year?]:
COUNTD(IF [Max Year?]=TRUE
THEN [number]
END)
}
Aggregation: Attribute
Measure: Time to Close an Incident
Role: Discrete Measure
Remote Column: [sqlproxy].[Calculation_519602849371926528]
Data Type: string
Formula: // This is a calculated field
// It transforms time in seconds into DD:HH:MM:SS format
STR(INT(AVG([Time to Close an Incident (seconds)])/86400))
+ " day(s) " +
IF (INT(AVG([Time to Close an Incident (seconds)])%86400/3600))
< 10 THEN "0" ELSE "" END + STR(INT(AVG([Time to Close an Incident (seconds)])%86400/3600))
+ ":" +
IF INT(AVG([Time to Close an Incident (seconds)])%3600/60)
< 10 THEN "0" ELSE "" END + STR(INT(AVG([Time to Close an Incident (seconds)])%3600/60))
+ ":" +
IF INT(AVG([Time to Close an Incident (seconds)]) %3600 %60)
< 10 THEN "0" ELSE "" END + STR(INT(AVG([Time to Close an Incident (seconds)]) %3600 %60))
Aggregation: User
Measure: Time to Close an Incident (seconds)
Role: Continous Measure
Remote Column: [sqlproxy].[Calculation_863846747596144657]
Data Type: integer
Formula: // This is a calculated field
// It calculates the difference in seconds between opening and closing an incident
// Check if closed date is valid
IF [closed_at]>[opened_at]
THEN
//Calculate difference
DATEDIFF('second', [opened_at], [closed_at])
END
Aggregation: Sum
Measure: Total Active Incidents
Role: Continous Measure
Remote Column: [sqlproxy].[Current Year Total Cases (copy)]
Data Type: integer
Formula: // This is a calculated field
// It counts each distinct incident. The "exclude" is used to avoid filters interfering in the final result
{EXCLUDE [opened_at], [Overdue], [Max Year?]:
COUNTD(IF [active]=TRUE
THEN [number]
END)
}
Aggregation: Attribute
Measure: Business resolve time (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[business_stc (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Resolve time (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[calendar_stc (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Child Incidents (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[child_incidents (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Escalation (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[escalation (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Escalation
Role: Continous Measure
Remote Column: [sqlproxy].[escalation]
Data Type: integer
Aggregation: Sum
Measure: Fault count
Role: Continous Measure
Remote Column: [sqlproxy].[fault_count]
Data Type: integer
Aggregation: Sum
Measure: Impact (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[impact (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Impact
Role: Continous Measure
Remote Column: [sqlproxy].[impact]
Data Type: integer
Aggregation: Sum
Measure: Incident state (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[incident_state (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Status
Role: Continous Measure
Remote Column: [sqlproxy].[install_status]
Data Type: integer
Aggregation: Sum
Measure: Notify (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[notify (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Operational status
Role: Continous Measure
Remote Column: [sqlproxy].[operational_status]
Data Type: integer
Aggregation: Sum
Measure: Order (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[order (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Order
Role: Continous Measure
Remote Column: [sqlproxy].[order]
Data Type: integer
Aggregation: Sum
Measure: Priority (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[priority (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Reassignment count (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[reassignment_count (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Reassignment count
Role: Continous Measure
Remote Column: [sqlproxy].[reassignment_count]
Data Type: integer
Aggregation: Sum
Measure: Reopen count (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[reopen_count (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Severity (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[severity (Incident)]
Data Type: integer
Aggregation: Sum
Measure: State (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[state (Incident)]
Data Type: integer
Aggregation: Sum
Measure: State
Role: Continous Measure
Remote Column: [sqlproxy].[state]
Data Type: integer
Aggregation: Sum
Measure: Updates (Configuration Item)
Role: Continous Measure
Remote Column: [sqlproxy].[sys_mod_count (Configuration Item)]
Data Type: integer
Aggregation: Sum
Measure: Updates (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[sys_mod_count (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Updates
Role: Continous Measure
Remote Column: [sqlproxy].[sys_mod_count]
Data Type: integer
Aggregation: Sum
Measure: Urgency (Incident)
Role: Continous Measure
Remote Column: [sqlproxy].[urgency (Incident)]
Data Type: integer
Aggregation: Sum
Measure: Urgency
Role: Continous Measure
Remote Column: [sqlproxy].[urgency]
Data Type: integer
Aggregation: Sum
Measure: Number of Records
Role: Continous Measure
Remote Column: [sqlproxy].[Number of Records]
Data Type: integer
Aggregation: Sum
Calculated/Other
Measure: % of Overdue
Role: Continous Measure
Data Type: real
Formula: // This is a calculated field
// It show the percentage incidents which are overdue
(IF ATTR([Overdue]="Overdue")
THEN COUNTD([number])
END)
/
ATTR({ EXCLUDE [Overdue]:
COUNTD([number])})
Aggregation: User
Measure: Measure Values
Role: Continous Measure
Data Type: real
Aggregation: Sum
Semantic Values
[Country].[Name]: "United States"
Dashboards
Dashboard: Executive Dashboard
Worksheets
Worksheet: Opened Incidents
Datasources: Incidents
Used Dimensions & Measures: [Active]
[Category (Incident)]
[Closed]
[Current Year Total Cases]
[Due date]
[Max Year?]
[Number]
[Opened Month Tooltip]
[Opened]
[Overdue]
[Priority]
[Total Active Incidents]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[Calculation_466404086152966145]
[sqlproxy].[Calculation_466404086156124162]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[category (Incident)]
[sqlproxy].[closed_at]
[sqlproxy].[Current Year Total Cases (copy)]
[sqlproxy].[due_date]
[sqlproxy].[number]
[sqlproxy].[Opened (copy)]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
Worksheet: Overdue
Datasources: Incidents
Used Dimensions & Measures: [% of Overdue]
[Active]
[Category (Incident)]
[Closed]
[Due date]
[Max Year?]
[Number]
[Opened]
[Overdue]
[Priority]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[Calculation_466404086156124162]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[category (Incident)]
[sqlproxy].[closed_at]
[sqlproxy].[due_date]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
Worksheet: AVG Time to Solve an Incident
Datasources: Incidents
Used Dimensions & Measures: [Active]
[Category (Incident)]
[Closed]
[Max Year?]
[Opened]
[Priority]
[Time to Close an Incident (seconds)]
[Time to Close an Incident]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[Calculation_519602849371926528]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[Calculation_863846747596144657]
[sqlproxy].[category (Incident)]
[sqlproxy].[closed_at]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
Worksheet: Total Incidents by Category and YoY Change
Datasources: Incidents
Used Dimensions & Measures: [Active]
[Category (Incident)]
[Closed]
[Current Year Total Cases]
[Due date]
[Max Year?]
[Number]
[Opened]
[Overdue]
[Priority]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[Calculation_466404086152966145]
[sqlproxy].[Calculation_466404086156124162]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[category (Incident)]
[sqlproxy].[closed_at]
[sqlproxy].[due_date]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
Worksheet: Opened Problems
Datasources: Incidents
Problems
Used Dimensions & Measures: [Active]
[Active]
[Closed]
[Current Year Total Cases]
[Due date]
[Max Year?]
[Number]
[Opened]
[Opened]
[Overdue]
[Priority]
[Priority]
[Total # Problems]
[Total Active Problems]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[active]
[sqlproxy].[Calculation_466404086152966145]
[sqlproxy].[Calculation_466404086156124162]
[sqlproxy].[Calculation_466404086465376264]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[closed_at]
[sqlproxy].[Current Year Total Cases (copy)]
[sqlproxy].[due_date]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
[sqlproxy].[priority]
Worksheet: Overdue Problems
Datasources: Incidents
Problems
Used Dimensions & Measures: [% of Overdue]
[Active]
[Active]
[Closed]
[Due date]
[Max Year?]
[Number]
[Opened]
[Opened]
[Overdue]
[Priority]
[Priority]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[active]
[sqlproxy].[Calculation_466404086156124162]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[closed_at]
[sqlproxy].[due_date]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
[sqlproxy].[priority]
Worksheet: High and Critical Priority Problems
Datasources: Incidents
Problems
Used Dimensions & Measures: [% of critical and high priority]
[Active]
[Active]
[Max Year?]
[Number]
[Opened]
[Opened]
[Priority]
[Priority]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[active]
[sqlproxy].[Calculation_217580207398023176]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
[sqlproxy].[priority]
Worksheet: Known Errors
Datasources: Incidents
Problems
Used Dimensions & Measures: [% of known error]
[Active]
[Active]
[Known error]
[Max Year?]
[Number]
[Opened]
[Opened]
[Priority]
[Priority]
[Problems with Related Incidents]
[Related Incidents]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[active]
[sqlproxy].[Calculation_217580207383207936]
[sqlproxy].[Calculation_217580207400972297]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[known_error]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
[sqlproxy].[priority]
[sqlproxy].[related_incidents]
Worksheet: Age of Active Problems
Datasources: Incidents
Problems
Used Dimensions & Measures: [Active]
[Active]
[Age of Problems]
[Max Year?]
[Number]
[Opened]
[Opened]
[Priority]
[Priority]
[Time Span Breakdown]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[active]
[sqlproxy].[Calculation_217580207388532741]
[sqlproxy].[Calculation_217580207391584262]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
[sqlproxy].[priority]
Worksheet: Opened Requests
Datasources: Incidents
Requests
Used Dimensions & Measures: [Active]
[Active]
[Closed]
[Current Year Total Cases]
[Due date]
[Max Year?]
[Number]
[Opened]
[Opened]
[Overdue]
[Priority]
[Priority]
[Total # Request]
[Total Active Requests]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[active]
[sqlproxy].[Calculation_466404086152966145]
[sqlproxy].[Calculation_466404086156124162]
[sqlproxy].[Calculation_466404086465376264]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[closed_at]
[sqlproxy].[Current Year Total Cases (copy)]
[sqlproxy].[due_date]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
[sqlproxy].[priority]
Worksheet: Overdue Requests
Datasources: Incidents
Requests
Used Dimensions & Measures: [% of Overdue]
[Active]
[Active]
[Closed]
[Due date]
[Number]
[Opened]
[Opened]
[Overdue]
[Priority]
[Priority]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[active]
[sqlproxy].[Calculation_466404086156124162]
[sqlproxy].[closed_at]
[sqlproxy].[due_date]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
[sqlproxy].[priority]
Worksheet: Made SLA?
Datasources: Incidents
Requests
Used Dimensions & Measures: [% made SLA]
[Active]
[Active]
[Made SLA]
[Number]
[Opened]
[Opened]
[Priority]
[Priority]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[active]
[sqlproxy].[Calculation_217580207412346890]
[sqlproxy].[made_sla]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
[sqlproxy].[priority]
Worksheet: Top 10 Items by Requests and YoY Change
Datasources: Incidents
Requests
Used Dimensions & Measures: [Active]
[Active]
[Closed]
[Current Year Total Cases]
[Due date]
[Max Year?]
[Name]
[Number]
[Opened]
[Opened]
[Overdue]
[Priority]
[Priority]
Used Remote Columns: [sqlproxy].[active]
[sqlproxy].[active]
[sqlproxy].[Calculation_466404086152966145]
[sqlproxy].[Calculation_466404086156124162]
[sqlproxy].[Calculation_820218105606950914]
[sqlproxy].[closed_at]
[sqlproxy].[due_date]
[sqlproxy].[name]
[sqlproxy].[number]
[sqlproxy].[opened_at]
[sqlproxy].[opened_at]
[sqlproxy].[priority]
[sqlproxy].[priority]
Dashboard Objects:
Filter: [Incidents].[YEAR(opened_at)]
Filter: [Incidents].[active]
Filter: [Incidents].[priority]
Text: Executive Dashboard
Text: Æ
Text: Æ
Text: Incidents
Text: Æ
Text: Problems
Text: Æ
Text: Requests
Worksheets
Worksheet: AVG Time to Solve an Incident
Visible: No
Used Datasources
Datasource: Incidents
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Category (Incident)
Remote Column: [sqlproxy].[category (Incident)]
Discrete Dimension: Closed
Remote Column: [sqlproxy].[closed_at]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Discrete Measure: Time to Close an Incident
Remote Column: [sqlproxy].[Calculation_519602849371926528]
Continous Measure: Time to Close an Incident (seconds)
Remote Column: [sqlproxy].[Calculation_863846747596144657]
Marks
Mark: All
Type: Automatic
Label: AVG Time To Solve an Incident <[Incidents].[Time to Close an Incident]>
View
Filters: [Incidents].[Action (Category (Incident))]
[Incidents].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
Slices: [Incidents].[YEAR(opened_at)]
[Incidents].[MONTH(opened_at)]
[Incidents].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
[Incidents].[Action (Category (Incident))]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: label
[Incidents].[MONTH(opened_at)]
text-format: iLLL
Style: table
Other
background-color: #00000000
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
font-family: Tableau Bold
line-visibility: on
line-pattern-only: dashed
stroke-size: 1
text-format: n#,##0;-#,##0
background-color: #ffffff00
font-size: 6
Style: title
Other
background-color: #e6e6e6
Worksheet: Age of Active Problems
Visible: No
Used Datasources
Datasource: Problems
Discrete Dimension: Time Span Breakdown
Remote Column: [sqlproxy].[Calculation_217580207391584262]
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: Age of Problems
Remote Column: [sqlproxy].[Calculation_217580207388532741]
Datasource: Incidents
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Automatic
Tooltip: Time Span: <[Problems].[Time Span Breakdown]>
Percentage of Problems: <[Problems].[number]>
View
Rows: [Problems].[Time Span Breakdown]
Columns: [Problems].[number]
Filters: [Problems].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
[Problems].[active]
Slices: [Problems].[active]
[Incidents].[MONTH(opened_at)]
[Incidents].[YEAR(opened_at)]
[Problems].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: axis
[Problems].[number]
display: false
Other
stroke-color: #e6e6e6
Style: label
[Problems].[Time Span Breakdown]
font-size: 8
Style: worksheet
rows
display-field-labels: false
Style: gridline
Other
stroke-size: 5
line-pattern-only: solid
line-visibility: off
Style: title
Other
background-color: #f2f2f3
Worksheet: High and Critical Priority Problems
Visible: No
Used Datasources
Datasource: Problems
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: % of critical and high priority
Remote Column: [sqlproxy].[Calculation_217580207398023176]
Datasource: Incidents
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Automatic
Label: Critical and High Priority
<[Problems].[% of critical and high priority]> of Total
View
Filters: [Problems].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
[Problems].[YEAR(opened_at)]
Slices: [Problems].[YEAR(opened_at)]
[Incidents].[MONTH(opened_at)]
[Incidents].[YEAR(opened_at)]
[Problems].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: table
Other
background-color: #00000000
Worksheet: Known Errors
Visible: No
Used Datasources
Datasource: Problems
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Known error
Remote Column: [sqlproxy].[known_error]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: % of known error
Remote Column: [sqlproxy].[Calculation_217580207383207936]
Discrete Measure: Problems with Related Incidents
Remote Column: [sqlproxy].[Calculation_217580207400972297]
Continous Measure: Related Incidents
Remote Column: [sqlproxy].[related_incidents]
Datasource: Incidents
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Automatic
Label: Known Errors: <[Problems].[% of known error]>
Probs with rel. Incidents: <[Problems].[Problems with Related Incidents]>
Tooltip: % of known error: <[Problems].[% of known error]>
Problems with Related Incidents: <[Problems].[Problems with Related Incidents]>
View
Filters: [Problems].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
[Problems].[YEAR(opened_at)]
Slices: [Problems].[YEAR(opened_at)]
[Incidents].[MONTH(opened_at)]
[Incidents].[YEAR(opened_at)]
[Problems].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: table
Other
background-color: #00000000
Worksheet: Made SLA?
Visible: No
Used Datasources
Datasource: Requests
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Made SLA
Remote Column: [sqlproxy].[made_sla]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: % made SLA
Remote Column: [sqlproxy].[Calculation_217580207412346890]
Datasource: Incidents
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Automatic
Label: Made SLA? <[Requests].[% made SLA]> of Total
Tooltip: % made SLA: <[Requests].[% made SLA]>
View
Slices: [Incidents].[MONTH(opened_at)]
[Incidents].[YEAR(opened_at)]
[Incidents].[active]
[Incidents].[priority]
Worksheet: Opened Incidents
Visible: No
Used Datasources
Datasource: Incidents
Discrete Dimension: Overdue
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Opened Month Tooltip
Remote Column: [sqlproxy].[Opened (copy)]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Category (Incident)
Remote Column: [sqlproxy].[category (Incident)]
Discrete Dimension: Closed
Remote Column: [sqlproxy].[closed_at]
Discrete Dimension: Due date
Remote Column: [sqlproxy].[due_date]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: Current Year Total Cases
Remote Column: [sqlproxy].[Calculation_466404086152966145]
Continous Measure: Total Active Incidents
Remote Column: [sqlproxy].[Current Year Total Cases (copy)]
Marks
Mark: All
Type: Line
Label: <[Incidents].[YEAR(opened_at)]>
Tooltip: <[Incidents].[ATTR(Opened (copy))]>
Opened Incidents: <[Incidents].[number]>
Breakdown by Priority
<Sheet name="Tooltip - Incident Breakdown by Priority" maxwidth="300" maxheight="300" filter="<All Fields>">
View
Rows: [Incidents].[number]
Columns: [Incidents].[MONTH(opened_at)]
Filters: [Incidents].[Action (Category (Incident))]
Slices: [Incidents].[YEAR(opened_at)]
[Incidents].[MONTH(opened_at)]
[Incidents].[Action (Category (Incident))]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: axis
[Incidents].[number]
auto-subtitle: true
width: 47
width: 47
Other
tick-color: #00000000
line-pattern-only: solid
line-visibility: off
Style: header
[Incidents].[YEAR(opened_at)]
background-color: #e6e6e6
Other
border-style: none
Style: label
[Incidents].[MONTH(opened_at)]
text-orientation: 0
font-size: 8
text-format: iLLLLL
[Incidents].[YEAR(opened_at)]
font-size: 8
font-family: Tableau Semibold
[Incidents].[number]
font-size: 8
font-size: 8
Style: pane
Other
border-width: 5
border-style: none
rows
border-style: solid
Style: table
Other
background-color: #ffffff
Style: worksheet
cols
display-field-labels: false
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
font-family: Tableau Bold
line-visibility: on
line-pattern-only: dashed
stroke-size: 1
text-format: n#,##0;-#,##0
background-color: #ffffff00
font-size: 6
Other
line-visibility: off
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-size: 1
Style: table-div
rows
line-pattern-only: solid
line-visibility: off
cols
stroke-size: 2
line-pattern-only: solid
stroke-color: #f5f5f5
line-visibility: off
Style: header-div
cols
line-visibility: off
Style: title
Other
background-color: #00000000
Style: quick-filter
[Incidents].[YEAR(opened_at)]
title: Year
Other
font-size: 8
background-color: #ffffff
Style: quick-filter-title
Other
font-family: Tableau Light
text-align: center
Worksheet: Opened Problems
Visible: No
Used Datasources
Datasource: Problems
Discrete Dimension: Overdue
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Closed
Remote Column: [sqlproxy].[closed_at]
Discrete Dimension: Due date
Remote Column: [sqlproxy].[due_date]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: Current Year Total Cases
Remote Column: [sqlproxy].[Calculation_466404086152966145]
Continous Measure: Total # Problems
Remote Column: [sqlproxy].[Calculation_466404086465376264]
Continous Measure: Total Active Problems
Remote Column: [sqlproxy].[Current Year Total Cases (copy)]
Datasource: Incidents
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Line
Tooltip: <[Problems].[MONTH(opened_at)]>
Opened problems: <[Problems].[number]>
Breakdown by Priority
<Sheet name="Tooltip - Problem Breakdown by Priority" maxwidth="300" maxheight="300" filter="<All Fields>">
View
Rows: [Problems].[number]
Columns: [Problems].[MONTH(opened_at)]
Slices: [Incidents].[MONTH(opened_at)]
[Incidents].[YEAR(opened_at)]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: axis
[Problems].[number]
auto-subtitle: true
width: 48
Other
line-pattern-only: solid
tick-color: #00000000
line-visibility: off
Style: header
[Problems].[YEAR(opened_at)]
height: 19
background-color: #e6e6e6
Other
border-style: none
Style: label
[Problems].[YEAR(opened_at)]
font-size: 8
font-family: Tableau Semibold
[Problems].[MONTH(opened_at)]
text-orientation: 0
font-family: Tableau Book
font-size: 8
text-format: iLLLLL
[Problems].[number]
font-size: 8
Style: pane
Other
border-style: none
Style: worksheet
cols
display-field-labels: false
Style: refline
refline0
stroke-size: 1
line-visibility: on
line-pattern-only: dashed
font-family: Tableau Bold
font-size: 6
fill-above: #00000000
fill-below: #00000000
text-format: n#,##0.0;-#,##0.0
background-color: #ffffff00
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-size: 2
stroke-color: #f5f5f5
Style: table-div
rows
line-visibility: off
cols
stroke-color: #f5f5f5
Style: header-div
cols
line-visibility: off
Style: quick-filter
[Problems].[YEAR(opened_at)]
title: Year:
Other
background-color: #e6e6e6
Style: quick-filter-title
Other
font-family: Tableau Bold
font-size: 8
Worksheet: Opened Requests
Visible: No
Used Datasources
Datasource: Requests
Discrete Dimension: Overdue
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Closed
Remote Column: [sqlproxy].[closed_at]
Discrete Dimension: Due date
Remote Column: [sqlproxy].[due_date]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: Current Year Total Cases
Remote Column: [sqlproxy].[Calculation_466404086152966145]
Continous Measure: Total # Request
Remote Column: [sqlproxy].[Calculation_466404086465376264]
Continous Measure: Total Active Requests
Remote Column: [sqlproxy].[Current Year Total Cases (copy)]
Datasource: Incidents
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Line
Tooltip: <[Requests].[MONTH(opened_at)]>
Opened Requests: <[Requests].[number]>
Breakdown by Priority
<Sheet name="Tooltip - Request Breakdown by Priority" maxwidth="300" maxheight="300" filter="<All Fields>">
View
Rows: [Requests].[number]
Columns: [Requests].[MONTH(opened_at)]
Slices: [Incidents].[MONTH(opened_at)]
[Incidents].[YEAR(opened_at)]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: axis
[Requests].[number]
auto-subtitle: true
width: 52
Other
line-pattern-only: solid
tick-color: #00000000
line-visibility: off
Style: header
[Requests].[YEAR(opened_at)]
background-color: #e6e6e6
Style: label
[Requests].[YEAR(opened_at)]
font-family: Tableau Semibold
font-size: 8
[Requests].[number]
font-size: 8
[Requests].[MONTH(opened_at)]
font-size: 8
text-orientation: 0
text-format: iLLLLL
Style: worksheet
cols
display-field-labels: false
Style: refline
refline0
line-visibility: on
line-pattern-only: dashed
stroke-size: 1
font-family: Tableau Bold
font-size: 6
fill-above: #00000000
fill-below: #00000000
text-format: n#,##0;-#,##0
Style: gridline
Other
line-visibility: on
line-pattern-only: solid
stroke-size: 2
Style: table-div
cols
stroke-color: #f5f5f5
rows
line-visibility: off
Style: header-div
cols
line-visibility: off
Style: quick-filter
[Requests].[YEAR(opened_at)]
title: Year:
Other
background-color: #e6e6e6
Style: quick-filter-title
Other
font-family: Tableau Bold
font-size: 8
text-align: left
Worksheet: Overdue
Visible: No
Used Datasources
Datasource: Incidents
Discrete Dimension: Overdue
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Category (Incident)
Remote Column: [sqlproxy].[category (Incident)]
Discrete Dimension: Closed
Remote Column: [sqlproxy].[closed_at]
Discrete Dimension: Due date
Remote Column: [sqlproxy].[due_date]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: % of Overdue
Marks
Mark: All
Type: Bar
View
Columns: [Incidents].[number]
Filters: [Incidents].[Action (Category (Incident))]
[Incidents].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
Slices: [Incidents].[YEAR(opened_at)]
[Incidents].[MONTH(opened_at)]
[Incidents].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
[Incidents].[Action (Category (Incident))]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: axis
[Incidents].[number]
auto-subtitle: true
height: 24
display: false
tick-color: #00000000
Other
line-visibility: off
Style: cell
[Incidents].[number]
text-format: p0%
font-size: 7
font-family: Tableau Book
Style: header
Other
border-style: none
Style: label
[Incidents].[MONTH(opened_at)]
text-format: iLLL
[Incidents].[number]
font-size: 7
Style: pane
Other
border-style: none
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
font-family: Tableau Bold
line-visibility: on
line-pattern-only: dashed
stroke-size: 1
text-format: n#,##0;-#,##0
background-color: #ffffff00
font-size: 6
Style: gridline
Other
line-pattern-only: solid
stroke-size: 2
line-visibility: off
Style: zeroline
Other
line-visibility: off
Style: table-div
cols
stroke-size: 2
line-visibility: on
line-pattern-only: solid
stroke-color: #ffffff
Style: title
Other
border-color: #f5f5f5
background-color: #00000000
border-style: none
Worksheet: Overdue Problems
Visible: No
Used Datasources
Datasource: Problems
Discrete Dimension: Overdue
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Closed
Remote Column: [sqlproxy].[closed_at]
Discrete Dimension: Due date
Remote Column: [sqlproxy].[due_date]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: % of Overdue
Datasource: Incidents
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Automatic
View
Columns: [Problems].[number]
Filters: [Problems].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
Slices: [Incidents].[MONTH(opened_at)]
[Incidents].[YEAR(opened_at)]
[Problems].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: axis
[Problems].[number]
auto-subtitle: true
display: false
Other
line-visibility: off
Style: label
[Problems].[number]
font-size: 5
cols
font-size: 8
Style: pane
Other
border-style: none
Style: gridline
Other
line-pattern-only: solid
stroke-size: 3
line-visibility: off
Style: zeroline
Other
line-visibility: off
Style: table-div
rows
stroke-size: 5
line-pattern-only: solid
line-visibility: off
cols
line-pattern-only: solid
stroke-size: 3
stroke-color: #e6e6e6
line-visibility: off
Worksheet: Overdue Requests
Visible: No
Used Datasources
Datasource: Requests
Discrete Dimension: Overdue
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Closed
Remote Column: [sqlproxy].[closed_at]
Discrete Dimension: Due date
Remote Column: [sqlproxy].[due_date]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: % of Overdue
Datasource: Incidents
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Automatic
View
Columns: [Requests].[number]
Slices: [Incidents].[MONTH(opened_at)]
[Incidents].[YEAR(opened_at)]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: axis
[Requests].[number]
auto-subtitle: true
display: false
cols
stroke-size: 2
Other
line-visibility: off
Style: gridline
cols
stroke-size: 2
stroke-color: #e6e6e6
line-visibility: off
Style: zeroline
Other
line-visibility: off
Style: table-div
cols
line-pattern-only: solid
stroke-size: 2
stroke-color: #e6e6e6
line-visibility: off
Worksheet: Sheet 1
Visible: No
Marks
Mark: All
Type: Automatic
View
Worksheet: Tooltip - Incident Breakdown by Priority
Visible: No
Used Datasources
Datasource: Incidents
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Automatic
View
Rows: [Incidents].[number]
Columns: [Incidents].[priority]
Filters: [Incidents].[Tooltip (Max Year?,YEAR(Opened),MONTH(Opened))]
Slices: [Incidents].[MONTH(opened_at)]
[Incidents].[YEAR(opened_at)]
[Incidents].[Tooltip (Max Year?,YEAR(Opened),MONTH(Opened))]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: axis
[Incidents].[number]
display: false
Style: worksheet
rows
display-field-labels: false
cols
display-field-labels: false
Worksheet: Tooltip - Problem Breakdown by Priority
Visible: No
Used Datasources
Datasource: Problems
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Datasource: Incidents
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Automatic
View
Rows: [Problems].[number]
Columns: [Problems].[priority]
Filters: [Problems].[Tooltip (Max Year?,YEAR(Opened),MONTH(Opened))]
Slices: [Incidents].[MONTH(opened_at)]
[Incidents].[active]
[Incidents].[priority]
[Incidents].[YEAR(opened_at)]
[Problems].[Tooltip (Max Year?,YEAR(Opened),MONTH(Opened))]
Styles
Style: axis
[Problems].[number]
display: false
Style: worksheet
cols
display-field-labels: false
Worksheet: Tooltip - Request Breakdown by Priority
Visible: No
Used Datasources
Datasource: Requests
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Datasource: Incidents
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Automatic
View
Rows: [Requests].[number]
Columns: [Requests].[priority]
Filters: [Requests].[Tooltip (Max Year?,YEAR(Opened),MONTH(Opened))]
Slices: [Incidents].[MONTH(opened_at)]
[Incidents].[active]
[Incidents].[priority]
[Incidents].[YEAR(opened_at)]
[Requests].[Tooltip (Max Year?,YEAR(Opened),MONTH(Opened))]
Styles
Style: axis
[Requests].[number]
display: false
Style: worksheet
cols
display-field-labels: false
Worksheet: Top 10 Items by Requests and YoY Change
Visible: No
Used Datasources
Datasource: Requests
Discrete Dimension: Overdue
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Closed
Remote Column: [sqlproxy].[closed_at]
Discrete Dimension: Due date
Remote Column: [sqlproxy].[due_date]
Discrete Dimension: Name
Remote Column: [sqlproxy].[name]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: Current Year Total Cases
Remote Column: [sqlproxy].[Calculation_466404086152966145]
Datasource: Incidents
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Marks
Mark: All
Type: Automatic
Tooltip: <[Requests].[name]>
Number of Incidents: <[Requests].[ATTR(Current Year Total Cases)]>
YoY Change: <[Requests].[pcdf:ctd:number]>
Mark: [Requests].[ATTR(Current Year Total Cases)]
Type: Automatic
Tooltip: <[Requests].[name]>
Number of Incidents: <[Requests].[ATTR(Current Year Total Cases)]>
YoY Change: <[Requests].[pcdf:ctd:number]>
Mark: [Requests].[pcdf:ctd:number]
Type: Automatic
Tooltip: <[Requests].[name]>
Number of Incidents: <[Requests].[ATTR(Current Year Total Cases)]>
YoY Change: <[Requests].[pcdf:ctd:number]>
View
Rows: [Requests].[name]
Columns: [Requests].[ATTR(Current Year Total Cases)]
[Requests].[pcdf:ctd:number]
Filters: [Requests].[name]
Manual Sorting: [Requests].[name] ASC
Slices: [Incidents].[MONTH(opened_at)]
[Incidents].[YEAR(opened_at)]
[Requests].[name]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: axis
[Requests].[ATTR(Current Year Total Cases)]
display: false
[Requests].[pcdf:ctd:number]
display: false
Other
stroke-color: #e6e6e6
Style: header
Other
height-header: 10
Style: label
[Requests].[name]
font-size: 8
Style: table
Other
show-null-value-warning: false
Style: worksheet
rows
display-field-labels: false
Style: gridline
Other
stroke-size: 5
line-pattern-only: solid
line-visibility: off
Style: table-div
rows
line-visibility: on
line-pattern-only: solid
stroke-color: #f5f5f5
div-level: 1
cols
stroke-size: 3
stroke-color: #f5f5f5
Style: header-div
rows
line-visibility: off
Style: title
Other
background-color: #f2f2f3
Worksheet: Total Incidents by Category and YoY Change
Visible: No
Used Datasources
Datasource: Incidents
Discrete Dimension: Overdue
Remote Column: [sqlproxy].[Calculation_466404086156124162]
Discrete Dimension: Max Year?
Remote Column: [sqlproxy].[Calculation_820218105606950914]
Discrete Dimension: Active
Remote Column: [sqlproxy].[active]
Discrete Dimension: Category (Incident)
Remote Column: [sqlproxy].[category (Incident)]
Discrete Dimension: Closed
Remote Column: [sqlproxy].[closed_at]
Discrete Dimension: Due date
Remote Column: [sqlproxy].[due_date]
Discrete Dimension: Number
Remote Column: [sqlproxy].[number]
Discrete Dimension: Opened
Remote Column: [sqlproxy].[opened_at]
Discrete Dimension: Priority
Remote Column: [sqlproxy].[priority]
Continous Measure: Current Year Total Cases
Remote Column: [sqlproxy].[Calculation_466404086152966145]
Marks
Mark: All
Type: Automatic
Tooltip: <[Incidents].[category (Incident)]>
Number of Incidents: <[Incidents].[ATTR(Current Year Total Cases)]>
YoY Change: <[Incidents].[pcdf:ctd:number]>
Mark: [Incidents].[ATTR(Current Year Total Cases)]
Type: Automatic
Tooltip: <[Incidents].[category (Incident)]>
Number of Incidents: <[Incidents].[ATTR(Current Year Total Cases)]>
YoY Change: <[Incidents].[pcdf:ctd:number]>
Mark: [Incidents].[pcdf:ctd:number]
Type: Automatic
Tooltip: <[Incidents].[category (Incident)]>
Number of Incidents: <[Incidents].[ATTR(Current Year Total Cases)]>
YoY Change: <[Incidents].[pcdf:ctd:number]>
View
Rows: [Incidents].[category (Incident)]
Columns: [Incidents].[ATTR(Current Year Total Cases)]
[Incidents].[pcdf:ctd:number]
Filters: [Incidents].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
Manual Sorting: [Incidents].[category (Incident)] ASC
Slices: [Incidents].[YEAR(opened_at)]
[Incidents].[MONTH(opened_at)]
[Incidents].[Action (Max Year?,YEAR(Opened),MONTH(Opened))]
[Incidents].[active]
[Incidents].[priority]
Styles
Style: axis
[Incidents].[pcdf:ctd:number]
display: false
Other
stroke-size: 1
stroke-color: #e6e6e6
tick-color: #00000000
cols
line-visibility: off
Style: header
Other
height-header: 10
[Incidents].[category (Incident)]
width: 150
Style: label
[Incidents].[MONTH(opened_at)]
text-format: iLLL
[Incidents].[category (Incident)]
font-weight: normal
font-family: Tableau Book
color: #666666
font-size: 8
[Incidents].[pcdf:ctd:number]
font-size: 8
Style: table
Other
show-null-value-warning: false
Style: worksheet
rows
display-field-labels: false
Style: refline
refline0
fill-above: #00000000
fill-below: #00000000
line-visibility: on
line-pattern-only: dashed
text-format: n#,##0;-#,##0
background-color: #ffffff00
font-size: 6
stroke-size: 1
stroke-color: #5555554b
font-family: Tableau Semibold
Style: gridline
Other
stroke-size: 5
line-pattern-only: solid
line-visibility: off
cols
line-pattern-only: solid
stroke-size: 2
line-visibility: off
rows
line-pattern-only: solid
stroke-size: 2
line-visibility: off
Style: table-div
cols
stroke-color: #f5f5f5
stroke-size: 5
rows
line-visibility: on
line-pattern-only: solid
div-level: 1
stroke-color: #f5f5f5
stroke-size: 1
Style: header-div
rows
stroke-color: #f5f5f5
line-visibility: off
Style: title
Other
border-width: 1
border-style: none
background-color: #f2f2f3