Skip to content

Instantly share code, notes, and snippets.

@yugako
Created April 6, 2023 08:12
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yugako/37e815f2cf02f66361f72005e00ff086 to your computer and use it in GitHub Desktop.
Save yugako/37e815f2cf02f66361f72005e00ff086 to your computer and use it in GitHub Desktop.
{
"__inputs": [
{
"name": "DS_COGNITE_DATA FUSION",
"label": "Cognite Data Fusion",
"description": "",
"type": "datasource",
"pluginId": "cognitedata-datasource",
"pluginName": "Cognite Data Fusion"
}
],
"__elements": {},
"__requires": [
{
"type": "datasource",
"id": "cognitedata-datasource",
"name": "Cognite Data Fusion",
"version": "3.0.0"
},
{
"type": "panel",
"id": "geomap",
"name": "Geomap",
"version": ""
},
{
"type": "grafana",
"id": "grafana",
"name": "Grafana",
"version": "9.5.0"
},
{
"type": "panel",
"id": "timeseries",
"name": "Time series",
"version": ""
}
],
"annotations": {
"list": [
{
"builtIn": 1,
"datasource": {
"type": "grafana",
"uid": "-- Grafana --"
},
"enable": true,
"hide": true,
"iconColor": "rgba(0, 211, 255, 1)",
"name": "Annotations & Alerts",
"target": {
"limit": 100,
"matchAny": false,
"tags": [],
"type": "dashboard"
},
"type": "dashboard"
}
]
},
"editable": true,
"fiscalYearStartMonth": 0,
"graphTooltip": 0,
"id": null,
"links": [],
"liveNow": false,
"panels": [
{
"datasource": {
"type": "cognitedata-datasource",
"uid": "${DS_COGNITE_DATA FUSION}"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "thresholds"
},
"custom": {
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 8,
"w": 12,
"x": 0,
"y": 0
},
"id": 3,
"options": {
"basemap": {
"config": {},
"name": "Layer 0",
"type": "default"
},
"controls": {
"mouseWheelZoom": true,
"showAttribution": true,
"showDebug": false,
"showMeasure": false,
"showScale": false,
"showZoom": true
},
"layers": [
{
"config": {
"showLegend": true,
"style": {
"color": {
"fixed": "dark-green"
},
"opacity": 0.4,
"rotation": {
"fixed": 0,
"max": 360,
"min": -360,
"mode": "mod"
},
"size": {
"fixed": 5,
"max": 15,
"min": 2
},
"symbol": {
"fixed": "img/icons/marker/circle.svg",
"mode": "fixed"
},
"textConfig": {
"fontSize": 12,
"offsetX": 0,
"offsetY": 0,
"textAlign": "center",
"textBaseline": "middle"
}
}
},
"location": {
"mode": "auto"
},
"name": "Layer 1",
"tooltip": true,
"type": "markers"
}
],
"tooltip": {
"mode": "details"
},
"view": {
"allLayers": true,
"id": "zero",
"lat": 0,
"lon": 0,
"zoom": 1
}
},
"pluginVersion": "9.5.0",
"targets": [
{
"aggregation": "average",
"assetQuery": {
"includeSubTimeseries": true,
"includeSubtrees": false,
"relationshipsQuery": {
"dataSetIds": [],
"depth": 1,
"isActiveAtTime": false,
"isTypeTimeseries": false,
"labels": {
"containsAny": []
},
"limit": 1000,
"sourceExternalIds": []
},
"target": "",
"withRelationships": false
},
"datasource": {
"type": "cognitedata-datasource",
"uid": "${DS_COGNITE_DATA FUSION}"
},
"eventQuery": {
"activeAtTimeRange": true,
"advancedFilter": "",
"aggregate": {
"name": "uniqueValues",
"properties": [],
"withAggregate": false
},
"columns": [
"externalId",
"type",
"subtype",
"description",
"startTime",
"endTime"
],
"expr": ""
},
"expr": "",
"extractionPipelinesQuery": {
"columns": [
"name",
"status",
"lastUpdatedTime",
"lastFailure",
"lastSeen",
"lastSuccess",
"schedule",
"data set",
"message"
],
"getRuns": false,
"limit": 1000,
"selections": []
},
"flexibleDataModellingQuery": {
"externalId": "",
"graphQlQuery": "{\n listMachine {\n edges {\n node {\n __typename\n MachineWeight\n Model\n Anomalies {\n externalId\n id\n name\n __typename\n }\n Availability {\n id\n name\n externalId\n __typename\n }\n }\n }\n }\n}",
"tsKeys": []
},
"granularity": "",
"label": "",
"latestValue": false,
"refId": "A",
"relationshipsQuery": {
"dataSetIds": [],
"depth": 1,
"isActiveAtTime": false,
"isTypeTimeseries": false,
"labels": {
"containsAny": []
},
"limit": 1000,
"sourceExternalIds": []
},
"tab": "Timeseries",
"target": "houston.ro.REMOTE_AI[73]",
"targetRefType": "externalId",
"templateQuery": {
"dataPath": "oEE_MachinesQuery.items",
"datapointsPath": "GoodQuantity.datapoints",
"graphQlQuery": "{\n oEE_MachinesQuery {\n items {\n Facility\n Line\n GoodQuantity {\n datapoints (start: $__from, end: $__to, , limit: 100){\n value\n timestamp\n }\n }\n }\n }\n}",
"groupBy": "Facility"
}
},
{
"aggregation": "average",
"assetQuery": {
"includeSubTimeseries": true,
"includeSubtrees": false,
"relationshipsQuery": {
"dataSetIds": [],
"depth": 1,
"isActiveAtTime": false,
"isTypeTimeseries": false,
"labels": {
"containsAny": []
},
"limit": 1000,
"sourceExternalIds": []
},
"target": "",
"withRelationships": false
},
"datasource": {
"type": "cognitedata-datasource",
"uid": "${DS_COGNITE_DATA FUSION}"
},
"eventQuery": {
"activeAtTimeRange": true,
"advancedFilter": "",
"aggregate": {
"name": "uniqueValues",
"properties": [],
"withAggregate": false
},
"columns": [
"externalId",
"type",
"subtype",
"description",
"startTime",
"endTime"
],
"expr": ""
},
"expr": "",
"extractionPipelinesQuery": {
"columns": [
"name",
"status",
"lastUpdatedTime",
"lastFailure",
"lastSeen",
"lastSuccess",
"schedule",
"data set",
"message"
],
"getRuns": false,
"limit": 1000,
"selections": []
},
"flexibleDataModellingQuery": {
"externalId": "",
"graphQlQuery": "{\n listMachine {\n edges {\n node {\n __typename\n MachineWeight\n Model\n Anomalies {\n externalId\n id\n name\n __typename\n }\n Availability {\n id\n name\n externalId\n __typename\n }\n }\n }\n }\n}",
"tsKeys": []
},
"granularity": "",
"hide": false,
"label": "",
"latestValue": true,
"refId": "B",
"relationshipsQuery": {
"dataSetIds": [],
"depth": 1,
"isActiveAtTime": false,
"isTypeTimeseries": false,
"labels": {
"containsAny": []
},
"limit": 1000,
"sourceExternalIds": []
},
"tab": "Timeseries",
"target": "houston.ro.REMOTE_AI[25]",
"targetRefType": "externalId",
"templateQuery": {
"dataPath": "oEE_MachinesQuery.items",
"datapointsPath": "GoodQuantity.datapoints",
"graphQlQuery": "{\n oEE_MachinesQuery {\n items {\n Facility\n Line\n GoodQuantity {\n datapoints (start: $__from, end: $__to, , limit: 100){\n value\n timestamp\n }\n }\n }\n }\n}",
"groupBy": "Facility"
}
}
],
"title": "Data layers issue",
"transformations": [],
"type": "geomap"
},
{
"datasource": {
"type": "cognitedata-datasource",
"uid": "${DS_COGNITE_DATA FUSION}"
},
"fieldConfig": {
"defaults": {
"color": {
"mode": "palette-classic"
},
"custom": {
"axisCenteredZero": false,
"axisColorMode": "text",
"axisLabel": "",
"axisPlacement": "auto",
"barAlignment": 0,
"drawStyle": "line",
"fillOpacity": 0,
"gradientMode": "none",
"hideFrom": {
"legend": false,
"tooltip": false,
"viz": false
},
"lineInterpolation": "linear",
"lineWidth": 1,
"pointSize": 5,
"scaleDistribution": {
"type": "linear"
},
"showPoints": "auto",
"spanNulls": false,
"stacking": {
"group": "A",
"mode": "none"
},
"thresholdsStyle": {
"mode": "off"
}
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"color": "green",
"value": null
},
{
"color": "red",
"value": 80
}
]
}
},
"overrides": []
},
"gridPos": {
"h": 9,
"w": 12,
"x": 0,
"y": 8
},
"id": 2,
"options": {
"legend": {
"calcs": [],
"displayMode": "list",
"placement": "bottom",
"showLegend": true
},
"tooltip": {
"mode": "single",
"sort": "none"
}
},
"targets": [
{
"aggregation": "average",
"assetQuery": {
"includeSubTimeseries": true,
"includeSubtrees": false,
"relationshipsQuery": {
"dataSetIds": [],
"depth": 1,
"isActiveAtTime": false,
"isTypeTimeseries": false,
"labels": {
"containsAny": []
},
"limit": 1000,
"sourceExternalIds": []
},
"target": "",
"withRelationships": false
},
"datasource": {
"type": "cognitedata-datasource",
"uid": "${DS_COGNITE_DATA FUSION}"
},
"eventQuery": {
"activeAtTimeRange": true,
"advancedFilter": "",
"aggregate": {
"name": "uniqueValues",
"properties": [],
"withAggregate": false
},
"columns": [
"externalId",
"type",
"subtype",
"description",
"startTime",
"endTime"
],
"expr": ""
},
"expr": "",
"extractionPipelinesQuery": {
"columns": [
"name",
"status",
"lastUpdatedTime",
"lastFailure",
"lastSeen",
"lastSuccess",
"schedule",
"data set",
"message"
],
"getRuns": false,
"limit": 1000,
"selections": []
},
"flexibleDataModellingQuery": {
"externalId": "",
"graphQlQuery": "{\n listMachine {\n edges {\n node {\n __typename\n MachineWeight\n Model\n Anomalies {\n externalId\n id\n name\n __typename\n }\n Availability {\n id\n name\n externalId\n __typename\n }\n }\n }\n }\n}",
"tsKeys": []
},
"granularity": "",
"label": "",
"latestValue": false,
"refId": "A",
"relationshipsQuery": {
"dataSetIds": [],
"depth": 1,
"isActiveAtTime": false,
"isTypeTimeseries": false,
"labels": {
"containsAny": []
},
"limit": 1000,
"sourceExternalIds": []
},
"tab": "Timeseries",
"target": "houston.ro.REMOTE_AI[34]",
"targetRefType": "externalId",
"templateQuery": {
"dataPath": "oEE_MachinesQuery.items",
"datapointsPath": "GoodQuantity.datapoints",
"graphQlQuery": "{\n oEE_MachinesQuery {\n items {\n Facility\n Line\n GoodQuantity {\n datapoints (start: $__from, end: $__to, , limit: 100){\n value\n timestamp\n }\n }\n }\n }\n}",
"groupBy": "Facility"
}
}
],
"title": "Panel Title",
"type": "timeseries"
}
],
"refresh": "",
"revision": 1,
"schemaVersion": 38,
"style": "dark",
"tags": [],
"templating": {
"list": []
},
"time": {
"from": "2023-02-19T17:19:26.111Z",
"to": "2023-02-26T04:00:02.613Z"
},
"timepicker": {},
"timezone": "",
"title": "New dashboard",
"uid": "Xakdux-Vz",
"version": 11,
"weekStart": ""
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment