KPIs - Highways Tasks Completed On Time / Late
This hub widget is included in the Highways package.
Description
This widget is a template, so it's offered by the From template menu when a user adds a widget to a hub.
Properties
This widget has the following properties.
| Property | Value |
|---|---|
| Name | KPIs - Highways Tasks Completed On Time / Late |
| Item ID | 6878e9b96c571718fb6b8238 |
| Type | Standard |
| Collection | Template |
| Context | Package |
| Show percentage bars | No |
| Default app | DataExplorer |
Data points
This widget has 8 data points, each querying the items below.
| Data point | Source | Targets | Icon | Colour |
|---|---|---|---|---|
| This year's Safety Inspections completed on time | Query | Highways Safety Inspections | icon-inspection-visual | #7bba6d |
| This year's Safety Inspections completed late | Query | Highways Safety Inspections | icon-inspection-visual | #ed592a |
| This year's Follow-Up Inspections completed on time | Query | Highways Follow-up Inspection | icon-inspection-hs | #8dc349 |
| This year's Follow-Up Inspections completed late | Query | Highways Follow-up Inspection | icon-inspection-hs | #ed592a |
| This year's Service Enquiry Inspections completed on time | Query | Highways Service Enquiry Inspection | icon-inspection-unknown | #7bba6d |
| This year's Service Enquiry Inspections completed late | Query | Highways Service Enquiry Inspection | icon-inspection-unknown | #ed592a |
| This year's Highways Jobs completed on time | Query | Highways Jobs | icon-resource-job | #7bba6d |
| This year's Highways Jobs completed late | Query | Highways Jobs | icon-resource-job | #ed592a |
Configuration
The full configuration of this widget, including each data point's query.
Show configuration (1165 lines)
{
"hasBars": false,
"defaultApp": "DataExplorer",
"type": "Standard",
"dataPoints": [
{
"id": "1e245e40-62e8-11f0-9937-9d8e12009c4e",
"name": "This year's Safety Inspections completed on time",
"style": {
"icon": "icon-inspection-visual",
"colour": "#7bba6d"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_highwaysSafetyInspectionsWeather_684c082e1c1e97ba487f62ec",
"attributes_highwaysSafetyInspectionsMethod_684c083f1c1e97ba487f63b6",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksStatus",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_inspectionsInspectionNumber",
"attributes_tasksTeam",
"attributes_tasksTeamMember"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysSafetyInspections_67b74aa8e716149b9424ffe9",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5bc5bdd281d088d177342c76"
]
}
}
]
},
{
"type": "Or",
"children": [
{
"type": "And",
"children": [
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "NotExists",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksEstimatedEndTime"
}
}
]
}
]
},
{
"type": "And",
"children": [
{
"type": "Exists",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksEstimatedEndTime"
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksEstimatedEndTime"
}
}
]
}
]
}
]
},
{
"type": "And",
"children": [
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
]
}
},
{
"id": "d6bc2520-62e6-11f0-9937-9d8e12009c4e",
"name": "This year's Safety Inspections completed late",
"style": {
"icon": "icon-inspection-visual",
"colour": "#ed592a"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_highwaysSafetyInspectionsMethod_684c083f1c1e97ba487f63b6",
"attributes_highwaysSafetyInspectionsWeather_684c082e1c1e97ba487f62ec",
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksStatus",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksRaisedTime",
"attributes_tasksTargetTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_inspectionsInspectionNumber"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysSafetyInspections_67b74aa8e716149b9424ffe9",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5bc5bdd281d088d177342c76"
]
}
}
]
},
{
"type": "Or",
"children": [
{
"type": "And",
"children": [
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "NotExists",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksEstimatedEndTime"
}
}
]
}
]
},
{
"type": "And",
"children": [
{
"type": "Exists",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksEstimatedEndTime"
}
}
]
},
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksEstimatedEndTime"
}
}
]
}
]
}
]
},
{
"type": "And",
"children": [
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
]
}
},
{
"id": "1fdefb00-62f2-11f0-86f5-0deca73b6c70",
"name": "This year's Follow-Up Inspections completed on time",
"style": {
"icon": "icon-inspection-hs",
"colour": "#8dc349"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_highwaysFollowupInspectionFollowupOutcome_67b74a30e716149b9424ffc2",
"attributes_inspectionsInspectionNumber"
],
"collectionCode": "Live",
"dodiCode": "designs_highwaysFollowupInspection_67b7452be716149b9424fef8",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "aace7470-62f2-11f0-86f5-0deca73b6c70",
"name": "This year's Follow-Up Inspections completed late",
"style": {
"icon": "icon-inspection-hs",
"colour": "#ed592a"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_highwaysFollowupInspectionFollowupOutcome_67b74a30e716149b9424ffc2",
"attributes_inspectionsInspectionNumber"
],
"collectionCode": "Live",
"dodiCode": "designs_highwaysFollowupInspection_67b7452be716149b9424fef8",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5bc5bdd281d088d177342c76"
]
}
}
]
},
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "30297150-62f4-11f0-86f5-0deca73b6c70",
"name": "This year's Service Enquiry Inspections completed on time",
"style": {
"icon": "icon-inspection-unknown",
"colour": "#7bba6d"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_inspectionsInspectionNumber",
"attributes_serviceEnquiryInspectionsServiceEnquiryOutcome_86b70589b8114ef0fc29df8c"
],
"collectionCode": "Live",
"dodiCode": "designs_highwaysServiceEnquiryInspection_67b744d0e716149b9424fe3f",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5bc5bdd281d088d177342c76"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "4c8e6cb0-62f4-11f0-86f5-0deca73b6c70",
"name": "This year's Service Enquiry Inspections completed late",
"style": {
"icon": "icon-inspection-unknown",
"colour": "#ed592a"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_inspectionsInspectionNumber",
"attributes_serviceEnquiryInspectionsServiceEnquiryOutcome_86b70589b8114ef0fc29df8c"
],
"collectionCode": "Live",
"dodiCode": "designs_highwaysServiceEnquiryInspection_67b744d0e716149b9424fe3f",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5bc5bdd281d088d177342c76"
]
}
}
]
},
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "536e51d0-62ef-11f0-86f5-0deca73b6c70",
"name": "This year's Highways Jobs completed on time",
"style": {
"icon": "icon-resource-job",
"colour": "#7bba6d"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "1e42e920-62f0-11f0-86f5-0deca73b6c70",
"name": "This year's Highways Jobs completed late",
"style": {
"icon": "icon-resource-job",
"colour": "#ed592a"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_tasksWithTaskTypesTaskType",
"attributes_tasksIdentifierAssetReferece",
"attributes_tasksIdentifierTaskLocation",
"attributes_tasksStatus",
"attributes_tasksPriority",
"attributes_tasksTeam",
"attributes_tasksTeamMember",
"attributes_tasksRaisedTime",
"attributes_tasksEstimatedStartTime",
"attributes_tasksEstimatedEndTime",
"attributes_tasksCompletionTime",
"attributes_tasksTargetTime",
"attributes_jobsJobNumber",
"attributes_jobsTotalEstimatedWorkItemCost",
"attributes_jobsTotalActualWorkItemCost"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysJobs_67e6472bcb15029b2c49ab4a",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_taskStatusesStatusType",
"path": "root.attributes_tasksStatus"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"5baa06686753092c3c858b07",
"5baa06706753092c3c858b08",
"5baa06736753092c3c858b09"
]
}
}
]
},
{
"type": "GreaterThan",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksCompletionTime"
}
},
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_tasksTargetTime"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
}
]
}