Thanks @agnestoulet1
et me try to make a json, I cannot make of only the panel as I cannot access the edit od the gauge chart
Ok I inlined the complete json, please let me know if you see anything interesting …
Best wishes,
Eric
{
“annotations”: {
“list”: [
{
“builtIn”: 1,
“datasource”: “-- Grafana --”,
“enable”: false,
“hide”: true,
“iconColor”: “#F2495C”,
“limit”: 100,
“name”: “Annotations & Alerts”,
“showIn”: 0,
“type”: “dashboard”
}
]
},
“editable”: true,
“gnetId”: null,
“graphTooltip”: 0,
“id”: 2,
“links”: ,
“panels”: [
{
“datasource”: “demo”,
“gridPos”: {
“h”: 11,
“w”: 12,
“x”: 0,
“y”: 0
},
“id”: 4,
“options”: {
“fieldOptions”: {
“calcs”: [
“mean”
],
“defaults”: {
“mappings”: ,
“max”: 150,
“thresholds”: {
“mode”: “absolute”,
“steps”: [
{
“color”: “green”,
“value”: null
},
{
“color”: “red”,
“value”: 80
}
]
}
},
“limit”: 250,
“overrides”: ,
“values”: true
},
“orientation”: “auto”,
“showThresholdLabels”: false,
“showThresholdMarkers”: true
},
“pluginVersion”: “6.6.2”,
“targets”: [
{
“groupBy”: [
{
“params”: [
“$__interval”
],
“type”: “time”
},
{
“params”: [
“null”
],
“type”: “fill”
}
],
“orderByTime”: “ASC”,
“policy”: “default”,
“query”: "SELECT last(value) from dxdata where analyte =‘Insulin’ and unit <> ‘…waiting…’ ",
“rawQuery”: true,
“refId”: “A”,
“resultFormat”: “time_series”,
“select”: [
[
{
“params”: [
“value”
],
“type”: “field”
},
{
“params”: ,
“type”: “mean”
}
]
],
“tags”:
}
],
“timeFrom”: null,
“timeShift”: null,
“title”: “Insulin Reading”,
“type”: “gauge”
},
{
“datasource”: “demo”,
“gridPos”: {
“h”: 16,
“w”: 24,
“x”: 0,
“y”: 11
},
“id”: 2,
“interval”: “”,
“options”: {},
“pconfig”: {
“fixScale”: “”,
“layout”: {
“dragmode”: “zoom”,
“font”: {
“family”: “"Open Sans", Helvetica, Arial, sans-serif”
},
“hovermode”: “closest”,
“legend”: {
“orientation”: “h”
},
“showlegend”: true,
“xaxis”: {
“rangemode”: “normal”,
“showgrid”: false,
“type”: “”,
“zeroline”: false
},
“yaxis”: {
“rangemode”: “tozero”,
“showgrid”: true,
“title”: “Insulin”,
“type”: “”,
“zeroline”: true
},
“zaxis”: {
“rangemode”: “normal”,
“showgrid”: true,
“type”: “linear”,
“zeroline”: false
}
},
“loadFromCDN”: false,
“settings”: {
“displayModeBar”: true,
“type”: “scatter”
},
“showAnnotations”: false,
“traces”: [
{
“mapping”: {
“color”: “dxdata”,
“size”: null,
“text”: null,
“x”: “dxdata@time”,
“y”: “dxdata”,
“z”: null
},
“name”: “Insulin”,
“settings”: {
“color_option”: “ramp”,
“line”: {
“color”: “#37872D”,
“dash”: “solid”,
“shape”: “linear”,
“width”: 4
},
“marker”: {
“color”: “#33B5E5”,
“colorscale”: “YlOrRd”,
“line”: {
“color”: “#DDD”,
“width”: 0
},
“showscale”: false,
“size”: 10,
“sizemin”: 3,
“sizemode”: “diameter”,
“sizeref”: 0.2,
“symbol”: “circle”
}
},
“show”: {
“line”: true,
“lines”: true,
“markers”: true
}
}
]
},
“targets”: [
{
“alias”: “”,
“groupBy”: [
{
“params”: [
“$__interval”
],
“type”: “time”
},
{
“params”: [
“null”
],
“type”: “fill”
}
],
“orderByTime”: “ASC”,
“policy”: “default”,
“query”: "SELECT value FROM "dxdata" WHERE analyte =‘Insulin’ AND unit <> ‘…waiting…’ AND $timeFilter “,
“rawQuery”: true,
“refId”: “A”,
“resultFormat”: “time_series”,
“select”: [
[
{
“params”: [
“value”
],
“type”: “field”
},
{
“params”: ,
“type”: “mean”
}
]
],
“tags”:
}
],
“timeFrom”: null,
“timeShift”: null,
“title”: “Insulin History”,
“transparent”: true,
“type”: “natel-plotly-panel”,
“version”: 1
}
],
“refresh”: “2s”,
“schemaVersion”: 22,
“style”: “dark”,
“tags”: ,
“templating”: {
“list”:
},
“time”: {
“from”: “now-30m”,
“to”: “now”
},
“timepicker”: {
“refresh_intervals”: [
“2s”,
" 5s”,
“10s”,
“30s”,
“1m”,
“5m”,
“15m”,
“30m”,
“1h”,
“2h”,
“1d”
]
},
“timezone”: “”,
“title”: “Meterbolic Real-time dashboard”,
“uid”: “2waiYmuZz”,
“version”: 15
}