KPIs - Defects by Category
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 - Defects by Category |
| Item ID | 6878e9b66c571718fb6b8237 |
| 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 Carriageway Defects | Query | Highways Defects | icon-network-road | #fc8150 |
| This year's Cycle Route Defects | Query | Highways Defects | icon-bike-line | #fc8150 |
| This year's Footway Defects | Query | Highways Defects | icon-footway-tacticle | #fc8150 |
| This year's Obstructions & Hazards Defects | Query | Highways Defects | icon-defect | #fc8150 |
| This year's Road Marks, Signs & Studs Defects | Query | Highways Defects | icon-road-markings-top | #fc8150 |
| This year's Street Furniture Defects | Query | Highways Defects | icon-bench | #fc8150 |
| This year's Vegetation & Verges Defects | Query | Highways Defects | icon-tree-grassed-area | #fc8150 |
| This year's S81 Defects | Query | Highways Defect - S81 Defective Apparatus | icon-defect-important | #fc8150 |
Configuration
The full configuration of this widget, including each data point's query.
Show configuration (860 lines)
{
"hasBars": false,
"defaultApp": "DataExplorer",
"type": "Standard",
"dataPoints": [
{
"id": "929f4470-62fb-11f0-86f5-0deca73b6c70",
"name": "This year's Carriageway Defects",
"style": {
"icon": "icon-network-road",
"colour": "#fc8150"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351",
"attributes_highwaysDefectsDefectDecision_67dbbeb5b932691ca1967522",
"attributes_highwaysDefectsOnsiteAction_67e128c9b932691ca1967b46",
"attributes_highwaysDefectsDecisionPriority_6851826fd720a5a5f70a4c90",
"attributes_defectsDefectNumber",
"attributes_defectsReportedDate",
"attributes_defectsRemediedDate",
"attributes_defectsStatus",
"attributes_defectsDescription",
"attributes_defectsDefectType",
"attributes_measurementWidth",
"attributes_measurementLength",
"attributes_measurementDepth",
"attributes_measurementQuantity"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysDefects_67dae589b932691ca1967037",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67dbf0a6b932691ca1967643"
]
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "977da150-6303-11f0-86f5-0deca73b6c70",
"name": "This year's Cycle Route Defects",
"style": {
"icon": "icon-bike-line",
"colour": "#fc8150"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351",
"attributes_highwaysDefectsDefectDecision_67dbbeb5b932691ca1967522",
"attributes_highwaysDefectsOnsiteAction_67e128c9b932691ca1967b46",
"attributes_highwaysDefectsDecisionPriority_6851826fd720a5a5f70a4c90",
"attributes_defectsDefectNumber",
"attributes_defectsReportedDate",
"attributes_defectsRemediedDate",
"attributes_defectsStatus",
"attributes_defectsDescription",
"attributes_defectsDefectType",
"attributes_measurementWidth",
"attributes_measurementLength",
"attributes_measurementDepth",
"attributes_measurementQuantity"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysDefects_67dae589b932691ca1967037",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67dbf0c1b932691ca1967659"
]
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "eda21700-6303-11f0-86f5-0deca73b6c70",
"name": "This year's Footway Defects",
"style": {
"icon": "icon-footway-tacticle",
"colour": "#fc8150"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351",
"attributes_highwaysDefectsDefectDecision_67dbbeb5b932691ca1967522",
"attributes_highwaysDefectsOnsiteAction_67e128c9b932691ca1967b46",
"attributes_highwaysDefectsDecisionPriority_6851826fd720a5a5f70a4c90",
"attributes_defectsDefectNumber",
"attributes_defectsReportedDate",
"attributes_defectsRemediedDate",
"attributes_defectsStatus",
"attributes_defectsDescription",
"attributes_defectsDefectType",
"attributes_measurementWidth",
"attributes_measurementLength",
"attributes_measurementDepth",
"attributes_measurementQuantity"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysDefects_67dae589b932691ca1967037",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67dbf0c8b932691ca1967665"
]
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "1d72fee0-6304-11f0-86f5-0deca73b6c70",
"name": "This year's Obstructions & Hazards Defects",
"style": {
"icon": "icon-defect",
"colour": "#fc8150"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351",
"attributes_highwaysDefectsDefectDecision_67dbbeb5b932691ca1967522",
"attributes_highwaysDefectsOnsiteAction_67e128c9b932691ca1967b46",
"attributes_highwaysDefectsDecisionPriority_6851826fd720a5a5f70a4c90",
"attributes_defectsDefectNumber",
"attributes_defectsReportedDate",
"attributes_defectsRemediedDate",
"attributes_defectsStatus",
"attributes_defectsDescription",
"attributes_defectsDefectType",
"attributes_measurementWidth",
"attributes_measurementLength",
"attributes_measurementDepth",
"attributes_measurementQuantity"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysDefects_67dae589b932691ca1967037",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67dbf0deb932691ca1967693"
]
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "3fd70300-6304-11f0-86f5-0deca73b6c70",
"name": "This year's Road Marks, Signs & Studs Defects",
"style": {
"icon": "icon-road-markings-top",
"colour": "#fc8150"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351",
"attributes_highwaysDefectsDefectDecision_67dbbeb5b932691ca1967522",
"attributes_highwaysDefectsOnsiteAction_67e128c9b932691ca1967b46",
"attributes_highwaysDefectsDecisionPriority_6851826fd720a5a5f70a4c90",
"attributes_defectsDefectNumber",
"attributes_defectsReportedDate",
"attributes_defectsRemediedDate",
"attributes_defectsStatus",
"attributes_defectsDescription",
"attributes_defectsDefectType",
"attributes_measurementWidth",
"attributes_measurementLength",
"attributes_measurementDepth",
"attributes_measurementQuantity"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysDefects_67dae589b932691ca1967037",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67dbf0f0b932691ca196769f"
]
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "51916ef0-6304-11f0-86f5-0deca73b6c70",
"name": "This year's Street Furniture Defects",
"style": {
"icon": "icon-bench",
"colour": "#fc8150"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351",
"attributes_highwaysDefectsDefectDecision_67dbbeb5b932691ca1967522",
"attributes_highwaysDefectsOnsiteAction_67e128c9b932691ca1967b46",
"attributes_highwaysDefectsDecisionPriority_6851826fd720a5a5f70a4c90",
"attributes_defectsDefectNumber",
"attributes_defectsReportedDate",
"attributes_defectsRemediedDate",
"attributes_defectsStatus",
"attributes_defectsDescription",
"attributes_defectsDefectType",
"attributes_measurementWidth",
"attributes_measurementLength",
"attributes_measurementDepth",
"attributes_measurementQuantity"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysDefects_67dae589b932691ca1967037",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67dbf0f8b932691ca19676ab"
]
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "64a72520-6304-11f0-86f5-0deca73b6c70",
"name": "This year's Vegetation & Verges Defects",
"style": {
"icon": "icon-tree-grassed-area",
"colour": "#fc8150"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"attributes": [
"attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351",
"attributes_highwaysDefectsDefectDecision_67dbbeb5b932691ca1967522",
"attributes_highwaysDefectsOnsiteAction_67e128c9b932691ca1967b46",
"attributes_highwaysDefectsDecisionPriority_6851826fd720a5a5f70a4c90",
"attributes_defectsDefectNumber",
"attributes_defectsReportedDate",
"attributes_defectsRemediedDate",
"attributes_defectsStatus",
"attributes_defectsDescription",
"attributes_defectsDefectType",
"attributes_measurementWidth",
"attributes_measurementLength",
"attributes_measurementDepth",
"attributes_measurementQuantity"
],
"collectionCode": "Live",
"dodiCode": "designInterfaces_highwaysDefects_67dae589b932691ca1967037",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "Equals",
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_highwaysDefectsHighwaysDefectCategory_67daffbcb932691ca1967351"
}
},
{
"type": "AlloyId",
"properties": {
"value": [
"67dbf106b932691ca19676b7"
]
}
}
]
},
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
},
{
"id": "95c94520-6304-11f0-86f5-0deca73b6c70",
"name": "This year's S81 Defects",
"style": {
"icon": "icon-defect-important",
"colour": "#fc8150"
},
"type": "CustomQuery",
"aqs": {
"type": "Query",
"properties": {
"collectionCode": "Live",
"dodiCode": "designs_highwaysDefectS81DefectiveApparatus_67e530d0d31cded80c23ea01",
"parameters": [
{
"name": "currentUserId",
"type": "AlloyId",
"title": "Current user ID"
}
]
},
"children": [
{
"type": "And",
"children": [
{
"type": "GreaterThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "StartOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
},
{
"type": "LessThan",
"properties": {
"inclusive": true
},
"children": [
{
"type": "Attribute",
"properties": {
"attributeCode": "attributes_defectsReportedDate"
}
},
{
"type": "RelativeDateTime",
"properties": {
"relativeTo": "EndOfYear",
"value": [
"0.00:00:00.000"
]
}
}
]
}
]
}
]
}
}
]
}