Time Series Data Service FAQs

Here you will find frequently asked questions regarding the Time Series Data Service. You’ll also find useful instructions on how to tailor the Time Series Data Service to your needs.

Time Series Data Service – Basics

This article contains:
Select data
Select visualization
General options

To get started with creating your own dashboards, please click the small user icon in the bottom left corner, click the “Switch” button and then press the small “switch to” button right behind your email address.

From that point on, you’ve switched to your personal organization, which allows you to create your own private dashboards, which only you can access.

Once you switched to your own organization you can create new dashboards by selecting the [+] button in the left sidebar. This will create an empty dashboard.

A dashboard consists of panels, which can be arranged in a number of ways. A new panel can be added to the dashboard by clicking the [Add Panel] at the top of the screen.

Select data

To retrieve data from your devices you must create a query. The query is sent to our cloud databases and provides you with the resulting data.
There is a graphical helper you can use to built your query in a point-and-click fashion.

  1. Click on [+] symbol on the left side of your screen, then on [Dashboard]
  2. Click on [Add Query] to start creating your new dashboard
  3. Select your data source from the dropdown right next to “Query”
  4. Build your query using the graphical editor
  5. Start by selecting a UUID in the “FROM”-row with clicking on the [+] right next to “where”
  6. Now select one of your UUIDs with a click on [select tag value]
  7. In the “FROM”-row, click now on [select measurement] so select what data should be displayed in your dashboard
  8. In the “SELECT”-row you now can change the field of the data inside the graph with clicking on the [+] next to “mean”
  9. In the “GROUP BY”-row you can set the interval of the data inside the graph
  10. You can give your data a new alias, with typing in a name in the row “ALIAS BY”
  11. If your data is written in a smaller frequency than in the “GROUP BY”-row, you can set it here
    If there is anything wrong with your query, check the red exclamation mark at the top left of your panel
Creation of a custom dashboard in the Time Series Data Service of the Proficloud.
Creation of a custom dashboard in the Time Series Data Service of the Proficloud.

This is the easiest way of visualization, what you select depends on what you want to see. The best way to learn how the methods work is to try them out.

Select visualization

Click on the graph at the left side of the panel you worked with so far
This tool enables you to personalize the graphic. Click on the box [Graph] next to Visualization

Now you could choose which visualization you want to have for your measurement. There are a few visualization options that can be chosen from. It should be noted that not every visualization is suitable for every type of data.

What you see depends on what you select. The best way to learn how the methods work is to try them out.

Visualization possibilities inside the time series data service of the Proficloud.

You can also add new visualization option using plugins or remove old ones you don’t need.

After Choosing a Visualization you can edit it to the extend you need to. Every Visualization has different settings ranging from changing the name to visualizing your data in different ways.

Options of the visualization of graphs inside the time series data service in the Proficloud

As an example, here you see the options for the Graph Visualization.

Now you can edit the visualization to the format you need. You could change the “Draw Mode” from Line to Bar, fill gaps with data, change the unit or scales of axes.
Just by trying the different type of options, you should get a greater understanding on how to make dashboards and personalize them.

General Options

In the box next to “Title” you can select the name of your Panel.

The option “Transparent” gives you the choice between a transparent and a nontransparent panel.

General options in custom dashboards inside the time series data service of the Proficloud

If you want, you can add a description, it supports markdown and links.

Like the templated dashboards from the PROFICLOUD-Organization and want to modify them on your own?

You can download the files here and import them to your own organization! Note that your modified dashboards do not receive template updates once you imported your own version.

Device template dashboard for all devices:

{
  "__inputs": [
    {
      "name": "DS_PROFICLOUD",
      "label": "Proficloud",
      "description": "",
      "type": "datasource",
      "pluginId": "influxdb",
      "pluginName": "InfluxDB"
    }
  ],
  "__requires": [
    {
      "type": "grafana",
      "id": "grafana",
      "name": "Grafana",
      "version": "7.4.2"
    },
    {
      "type": "panel",
      "id": "graph",
      "name": "Graph",
      "version": ""
    },
    {
      "type": "datasource",
      "id": "influxdb",
      "name": "InfluxDB",
      "version": "1.0.0"
    },
    {
      "type": "panel",
      "id": "stat",
      "name": "Stat",
      "version": ""
    },
    {
      "type": "panel",
      "id": "table",
      "name": "Table",
      "version": ""
    }
  ],
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": "-- Grafana --",
        "enable": true,
        "hide": true,
        "iconColor": "rgba(0, 211, 255, 1)",
        "name": "Annotations & Alerts",
        "type": "dashboard"
      }
    ]
  },
  "description": "Default template for device data view",
  "editable": true,
  "gnetId": null,
  "graphTooltip": 0,
  "id": null,
  "iteration": 1617691854610,
  "links": [],
  "panels": [
    {
      "collapsed": false,
      "datasource": "${DS_PROFICLOUD}",
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 0
      },
      "id": 14,
      "panels": [],
      "title": "Health",
      "type": "row"
    },
    {
      "cacheTimeout": null,
      "datasource": "${DS_PROFICLOUD}",
      "description": "Device Status\n\nFor more information please check the Proficloud Device Manager",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {},
          "mappings": [
            {
              "id": 0,
              "op": "=",
              "text": "No data in selected time range",
              "type": 1,
              "value": "null"
            },
            {
              "id": 1,
              "op": "=",
              "text": "No Action needed",
              "type": 1,
              "value": "0"
            },
            {
              "id": 2,
              "op": "=",
              "text": "Action needed",
              "type": 1,
              "value": "1"
            },
            {
              "id": 3,
              "op": "=",
              "text": "Device failure - Action needed",
              "type": 1,
              "value": "2"
            }
          ],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "rgba(255, 255, 255, 0)",
                "value": null
              },
              {
                "color": "rgb(255, 204, 0)",
                "value": 1
              },
              {
                "color": "rgb(245, 20, 35)",
                "value": 2
              }
            ]
          },
          "unit": "none"
        },
        "overrides": []
      },
      "gridPos": {
        "h": 2,
        "w": 24,
        "x": 0,
        "y": 1
      },
      "id": 4,
      "interval": null,
      "links": [],
      "maxDataPoints": 100,
      "options": {
        "colorMode": "background",
        "graphMode": "none",
        "justifyMode": "auto",
        "orientation": "horizontal",
        "reduceOptions": {
          "calcs": [
            "lastNotNull"
          ],
          "fields": "",
          "values": false
        },
        "text": {},
        "textMode": "value"
      },
      "pluginVersion": "7.4.2",
      "targets": [
        {
          "groupBy": [],
          "measurement": "con_trafficlights",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "con_TrafficLightColor"
                ],
                "type": "field"
              }
            ]
          ],
          "tags": [
            {
              "key": "kaaEndpointID",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "timeFrom": "10m",
      "timeShift": null,
      "title": "Device Status",
      "type": "stat"
    },
    {
      "datasource": "${DS_PROFICLOUD}",
      "description": "",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "align": null,
            "filterable": false
          },
          "decimals": 2,
          "displayName": "Status Message",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "short"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Time"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Time"
              },
              {
                "id": "custom.align",
                "value": null
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 3,
        "w": 24,
        "x": 0,
        "y": 3
      },
      "id": 10,
      "options": {
        "showHeader": true
      },
      "pluginVersion": "7.4.2",
      "targets": [
        {
          "groupBy": [],
          "measurement": "con_trafficlights",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "table",
          "select": [
            [
              {
                "params": [
                  "con_TrafficLightMessage"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "last"
              }
            ]
          ],
          "tags": [
            {
              "key": "kaaEndpointID",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "timeFrom": "10m",
      "timeShift": null,
      "title": "Status Message",
      "transformations": [
        {
          "id": "merge",
          "options": {
            "reducers": []
          }
        }
      ],
      "type": "table"
    },
    {
      "datasource": "${DS_PROFICLOUD}",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "align": null,
            "filterable": false
          },
          "decimals": 0,
          "displayName": "",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "short"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Time"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Time"
              },
              {
                "id": "unit",
                "value": "time: YYYY-MM-DD HH:mm:ss"
              },
              {
                "id": "custom.align",
                "value": null
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 7,
        "w": 24,
        "x": 0,
        "y": 6
      },
      "id": 6,
      "options": {
        "showHeader": true
      },
      "pluginVersion": "7.4.2",
      "targets": [
        {
          "alias": "$col",
          "groupBy": [],
          "hide": false,
          "measurement": "con_logs",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT \"con_LogLevel\", \"con_LogMessage\", \"con_LogTags\" FROM \"con_logs\" WHERE (\"kaaEndpointID\" = '$uuid') AND $timeFilter",
          "rawQuery": false,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "con_LogLevel"
                ],
                "type": "field"
              },
              {
                "params": [
                  "Log Level"
                ],
                "type": "alias"
              }
            ],
            [
              {
                "params": [
                  "con_LogMessage"
                ],
                "type": "field"
              },
              {
                "params": [
                  "Log Message"
                ],
                "type": "alias"
              }
            ],
            [
              {
                "params": [
                  "con_LogTags"
                ],
                "type": "field"
              },
              {
                "params": [
                  "Log Tags"
                ],
                "type": "alias"
              }
            ]
          ],
          "tags": [
            {
              "key": "kaaEndpointID",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "timeFrom": null,
      "timeShift": null,
      "title": "Log Messages",
      "transformations": [
        {
          "id": "seriesToColumns",
          "options": {
            "reducers": []
          }
        }
      ],
      "type": "table"
    },
    {
      "collapsed": false,
      "datasource": "${DS_PROFICLOUD}",
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 13
      },
      "id": 12,
      "panels": [],
      "repeat": null,
      "title": "Metrics",
      "type": "row"
    },
    {
      "aliasColors": {},
      "bars": false,
      "dashLength": 10,
      "dashes": false,
      "datasource": "${DS_PROFICLOUD}",
      "description": "",
      "fieldConfig": {
        "defaults": {
          "custom": {},
          "links": []
        },
        "overrides": []
      },
      "fill": 1,
      "fillGradient": 0,
      "gridPos": {
        "h": 9,
        "w": 24,
        "x": 0,
        "y": 14
      },
      "hiddenSeries": false,
      "id": 8,
      "legend": {
        "avg": false,
        "current": false,
        "max": false,
        "min": false,
        "show": true,
        "total": false,
        "values": false
      },
      "lines": true,
      "linewidth": 1,
      "maxPerRow": 4,
      "nullPointMode": "null",
      "options": {
        "alertThreshold": true
      },
      "percentage": false,
      "pluginVersion": "7.4.2",
      "pointradius": 2,
      "points": false,
      "renderer": "flot",
      "repeat": "metrics",
      "repeatDirection": "v",
      "seriesOverrides": [],
      "spaceLength": 10,
      "stack": false,
      "steppedLine": false,
      "targets": [
        {
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "/^$metrics$/",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT * WHERE (\"kaaEndpointID\" =~ /^$uuid$/) AND $timeFilter",
          "rawQuery": false,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "*"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "kaaEndpointID",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "thresholds": [],
      "timeFrom": null,
      "timeRegions": [],
      "timeShift": null,
      "title": "$metrics",
      "tooltip": {
        "shared": true,
        "sort": 0,
        "value_type": "individual"
      },
      "type": "graph",
      "xaxis": {
        "buckets": null,
        "mode": "time",
        "name": null,
        "show": true,
        "values": []
      },
      "yaxes": [
        {
          "format": "short",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        },
        {
          "format": "short",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        }
      ],
      "yaxis": {
        "align": false,
        "alignLevel": null
      }
    }
  ],
  "refresh": "10s",
  "schemaVersion": 27,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": [
      {
        "allValue": null,
        "current": {},
        "datasource": "${DS_PROFICLOUD}",
        "definition": "SHOW UUIDS",
        "description": null,
        "error": null,
        "hide": 0,
        "includeAll": false,
        "label": "UUID:",
        "multi": false,
        "name": "uuid",
        "options": [],
        "query": "SHOW UUIDS",
        "refresh": 1,
        "regex": "",
        "skipUrlSync": false,
        "sort": 0,
        "tagValuesQuery": "",
        "tags": [],
        "tagsQuery": "",
        "type": "query",
        "useTags": false
      },
      {
        "allValue": null,
        "current": {},
        "datasource": "${DS_PROFICLOUD}",
        "definition": "SHOW SERIES WHERE \"kaaEndpointID\" = '$uuid' AND $timeFilter",
        "description": null,
        "error": null,
        "hide": 2,
        "includeAll": true,
        "label": "Select Metric:",
        "multi": true,
        "name": "metrics",
        "options": [],
        "query": "SHOW SERIES WHERE \"kaaEndpointID\" = '$uuid' AND $timeFilter",
        "refresh": 2,
        "regex": "/^(?!con_|timestamp|auto~con_LogLevel|auto~con_TrafficLightColor|auto~timestamp|auto~con_UpdateId|auto~con_UpdateStatus)([^,]+)/",
        "skipUrlSync": false,
        "sort": 5,
        "tagValuesQuery": "",
        "tags": [],
        "tagsQuery": "",
        "type": "query",
        "useTags": false
      }
    ]
  },
  "time": {
    "from": "now-1h",
    "to": "now"
  },
  "timepicker": {
    "refresh_intervals": [
      "10s",
      "30s",
      "1m",
      "5m",
      "15m",
      "30m",
      "1h",
      "2h",
      "1d"
    ]
  },
  "timezone": "",
  "title": "Device Template",
  "uid": "device_basic_template",
  "version": 12
}

EMpro template:

{
  "__inputs": [
    {
      "name": "DS_PROFICLOUD",
      "label": "Proficloud",
      "description": "",
      "type": "datasource",
      "pluginId": "influxdb",
      "pluginName": "InfluxDB"
    }
  ],
  "__requires": [
    {
      "type": "grafana",
      "id": "grafana",
      "name": "Grafana",
      "version": "7.4.2"
    },
    {
      "type": "panel",
      "id": "graph",
      "name": "Graph",
      "version": ""
    },
    {
      "type": "datasource",
      "id": "influxdb",
      "name": "InfluxDB",
      "version": "1.0.0"
    },
    {
      "type": "panel",
      "id": "singlestat",
      "name": "Singlestat",
      "version": ""
    },
    {
      "type": "panel",
      "id": "table",
      "name": "Table",
      "version": ""
    }
  ],
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": "-- Grafana --",
        "enable": true,
        "hide": true,
        "iconColor": "rgba(0, 211, 255, 1)",
        "name": "Annotations & Alerts",
        "type": "dashboard"
      }
    ]
  },
  "editable": true,
  "gnetId": null,
  "graphTooltip": 0,
  "id": null,
  "iteration": 1617691881604,
  "links": [],
  "panels": [
    {
      "collapsed": false,
      "datasource": "${DS_PROFICLOUD}",
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 0
      },
      "id": 18,
      "panels": [],
      "title": "Health",
      "type": "row"
    },
    {
      "cacheTimeout": null,
      "colorBackground": true,
      "colorValue": false,
      "colors": [
        "rgba(41, 156, 70, 0)",
        "rgb(255, 204, 0)",
        "rgb(245, 20, 35)"
      ],
      "datasource": "${DS_PROFICLOUD}",
      "description": "Device Status\n\nFor more information please check the Proficloud Device Manager",
      "fieldConfig": {
        "defaults": {
          "custom": {}
        },
        "overrides": []
      },
      "format": "none",
      "gauge": {
        "maxValue": 100,
        "minValue": 0,
        "show": false,
        "thresholdLabels": false,
        "thresholdMarkers": true
      },
      "gridPos": {
        "h": 2,
        "w": 24,
        "x": 0,
        "y": 1
      },
      "id": 20,
      "interval": null,
      "links": [],
      "mappingType": 1,
      "mappingTypes": [
        {
          "$$hashKey": "object:119",
          "name": "value to text",
          "value": 1
        },
        {
          "$$hashKey": "object:120",
          "name": "range to text",
          "value": 2
        }
      ],
      "maxDataPoints": 100,
      "nullPointMode": "connected",
      "nullText": null,
      "postfix": "",
      "postfixFontSize": "50%",
      "prefix": "",
      "prefixFontSize": "50%",
      "rangeMaps": [
        {
          "from": "null",
          "text": "N/A",
          "to": "null"
        }
      ],
      "sparkline": {
        "fillColor": "rgba(31, 118, 189, 0.18)",
        "full": false,
        "lineColor": "rgb(31, 120, 193)",
        "show": false,
        "ymax": null,
        "ymin": null
      },
      "tableColumn": "",
      "targets": [
        {
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT \"con_TrafficLightColor\" FROM \"con_trafficlights\" WHERE (\"uuid\" = '$uuid') AND $timeFilter",
          "rawQuery": true,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": []
        }
      ],
      "thresholds": "1,2",
      "timeFrom": "10m",
      "timeShift": null,
      "title": "",
      "type": "singlestat",
      "valueFontSize": "50%",
      "valueMaps": [
        {
          "$$hashKey": "object:122",
          "op": "=",
          "text": "No data in selected time range",
          "value": "null"
        },
        {
          "$$hashKey": "object:123",
          "op": "=",
          "text": "No Action needed",
          "value": "0"
        },
        {
          "$$hashKey": "object:124",
          "op": "=",
          "text": "Action needed",
          "value": "1"
        },
        {
          "$$hashKey": "object:125",
          "op": "=",
          "text": "Device failure - Action needed",
          "value": "2"
        }
      ],
      "valueName": "current"
    },
    {
      "datasource": "${DS_PROFICLOUD}",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "align": "",
            "filterable": false
          },
          "decimals": 2,
          "displayName": "Status Message",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "short"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Time"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Time"
              },
              {
                "id": "custom.align",
                "value": null
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 3,
        "w": 24,
        "x": 0,
        "y": 3
      },
      "id": 22,
      "options": {
        "showHeader": true
      },
      "pluginVersion": "7.4.2",
      "targets": [
        {
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT last(\"con_TrafficLightMessage\") FROM \"con_trafficlights\" WHERE (\"uuid\" = '$uuid') AND $timeFilter",
          "rawQuery": true,
          "refId": "A",
          "resultFormat": "table",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": []
        }
      ],
      "timeFrom": "10m",
      "timeShift": null,
      "title": "",
      "transformations": [
        {
          "id": "merge",
          "options": {
            "reducers": []
          }
        }
      ],
      "type": "table"
    },
    {
      "datasource": "${DS_PROFICLOUD}",
      "fieldConfig": {
        "defaults": {
          "color": {
            "mode": "thresholds"
          },
          "custom": {
            "align": "",
            "filterable": false
          },
          "decimals": 0,
          "displayName": "",
          "mappings": [],
          "thresholds": {
            "mode": "absolute",
            "steps": [
              {
                "color": "green",
                "value": null
              },
              {
                "color": "red",
                "value": 80
              }
            ]
          },
          "unit": "short"
        },
        "overrides": [
          {
            "matcher": {
              "id": "byName",
              "options": "Time"
            },
            "properties": [
              {
                "id": "displayName",
                "value": "Time"
              },
              {
                "id": "unit",
                "value": "time: YYYY-MM-DD HH:mm:ss"
              },
              {
                "id": "custom.align",
                "value": null
              }
            ]
          }
        ]
      },
      "gridPos": {
        "h": 5,
        "w": 24,
        "x": 0,
        "y": 6
      },
      "id": 24,
      "options": {
        "showHeader": true
      },
      "pluginVersion": "7.4.2",
      "targets": [
        {
          "alias": "$col",
          "groupBy": [],
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT \"con_LogLevel\" AS \"Log Level\", \"con_LogMessage\" AS \"Log Message\", \"con_LogTags\" AS \"Log Tags\" FROM \"con_logs\" WHERE (\"uuid\" = '$uuid') AND $timeFilter",
          "rawQuery": true,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": []
        }
      ],
      "timeFrom": null,
      "timeShift": null,
      "title": "Log Messages",
      "transformations": [
        {
          "id": "seriesToColumns",
          "options": {
            "reducers": []
          }
        }
      ],
      "type": "table"
    },
    {
      "collapsed": false,
      "datasource": "${DS_PROFICLOUD}",
      "gridPos": {
        "h": 1,
        "w": 24,
        "x": 0,
        "y": 11
      },
      "id": 16,
      "panels": [],
      "title": "EMPRO",
      "type": "row"
    },
    {
      "aliasColors": {},
      "bars": true,
      "dashLength": 10,
      "dashes": false,
      "datasource": "${DS_PROFICLOUD}",
      "fieldConfig": {
        "defaults": {
          "custom": {},
          "links": []
        },
        "overrides": []
      },
      "fill": 1,
      "fillGradient": 0,
      "gridPos": {
        "h": 8,
        "w": 24,
        "x": 0,
        "y": 12
      },
      "hiddenSeries": false,
      "id": 4,
      "legend": {
        "alignAsTable": true,
        "avg": true,
        "current": false,
        "max": true,
        "min": true,
        "show": true,
        "total": true,
        "values": true
      },
      "lines": false,
      "linewidth": 1,
      "nullPointMode": "null",
      "options": {
        "alertThreshold": true
      },
      "percentage": false,
      "pluginVersion": "7.4.2",
      "pointradius": 2,
      "points": false,
      "renderer": "flot",
      "seriesOverrides": [],
      "spaceLength": 10,
      "stack": false,
      "steppedLine": false,
      "targets": [
        {
          "alias": "E",
          "groupBy": [
            {
              "params": [
                "$timerange"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~P",
          "orderByTime": "ASC",
          "policy": "default",
          "query": "SELECT integral(\"value\") FROM \"P\" WHERE (\"kaaEndpointID\" = '6c11bdb0-9212-42a7-8f9b-53ac9bb245ab') AND $timeFilter GROUP BY time($__interval) fill(null)",
          "rawQuery": false,
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "integral"
              },
              {
                "params": [
                  " / 3600"
                ],
                "type": "math"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "thresholds": [],
      "timeFrom": null,
      "timeRegions": [],
      "timeShift": null,
      "title": "Total Active Energy",
      "tooltip": {
        "shared": true,
        "sort": 0,
        "value_type": "individual"
      },
      "type": "graph",
      "xaxis": {
        "buckets": null,
        "mode": "time",
        "name": null,
        "show": true,
        "values": []
      },
      "yaxes": [
        {
          "format": "watth",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        },
        {
          "format": "short",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        }
      ],
      "yaxis": {
        "align": false,
        "alignLevel": null
      }
    },
    {
      "aliasColors": {},
      "bars": false,
      "dashLength": 10,
      "dashes": false,
      "datasource": "${DS_PROFICLOUD}",
      "fieldConfig": {
        "defaults": {
          "custom": {},
          "links": []
        },
        "overrides": []
      },
      "fill": 0,
      "fillGradient": 0,
      "gridPos": {
        "h": 8,
        "w": 24,
        "x": 0,
        "y": 20
      },
      "hiddenSeries": false,
      "id": 2,
      "legend": {
        "alignAsTable": true,
        "avg": true,
        "current": true,
        "max": true,
        "min": true,
        "rightSide": false,
        "show": true,
        "total": false,
        "values": true
      },
      "lines": true,
      "linewidth": 1,
      "nullPointMode": "null",
      "options": {
        "alertThreshold": true
      },
      "percentage": false,
      "pluginVersion": "7.4.2",
      "pointradius": 2,
      "points": false,
      "renderer": "flot",
      "seriesOverrides": [],
      "spaceLength": 10,
      "stack": false,
      "steppedLine": false,
      "targets": [
        {
          "alias": "P",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~P",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "thresholds": [
        {
          "colorMode": "warning",
          "fill": false,
          "line": true,
          "op": "gt",
          "value": 230,
          "yaxis": "left"
        },
        {
          "colorMode": "critical",
          "fill": false,
          "fillColor": "rgba(50, 116, 217, 0.2)",
          "line": true,
          "lineColor": "rgba(31, 96, 196, 0.6)",
          "op": "gt",
          "value": 300,
          "yaxis": "left"
        }
      ],
      "timeFrom": null,
      "timeRegions": [],
      "timeShift": null,
      "title": "Total Active Power",
      "tooltip": {
        "shared": true,
        "sort": 0,
        "value_type": "individual"
      },
      "type": "graph",
      "xaxis": {
        "buckets": null,
        "mode": "time",
        "name": null,
        "show": true,
        "values": []
      },
      "yaxes": [
        {
          "format": "watt",
          "label": "",
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        },
        {
          "format": "short",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        }
      ],
      "yaxis": {
        "align": false,
        "alignLevel": null
      }
    },
    {
      "aliasColors": {},
      "bars": false,
      "dashLength": 10,
      "dashes": false,
      "datasource": "${DS_PROFICLOUD}",
      "fieldConfig": {
        "defaults": {
          "custom": {},
          "links": []
        },
        "overrides": []
      },
      "fill": 0,
      "fillGradient": 0,
      "gridPos": {
        "h": 8,
        "w": 24,
        "x": 0,
        "y": 28
      },
      "hiddenSeries": false,
      "id": 10,
      "legend": {
        "alignAsTable": true,
        "avg": true,
        "current": true,
        "max": true,
        "min": true,
        "show": true,
        "total": false,
        "values": true
      },
      "lines": true,
      "linewidth": 1,
      "nullPointMode": "null",
      "options": {
        "alertThreshold": true
      },
      "percentage": false,
      "pluginVersion": "7.4.2",
      "pointradius": 2,
      "points": false,
      "renderer": "flot",
      "seriesOverrides": [],
      "spaceLength": 10,
      "stack": false,
      "steppedLine": false,
      "targets": [
        {
          "alias": "P",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~P",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        },
        {
          "alias": "Q",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~Q",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        },
        {
          "alias": "S",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~S",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "C",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "thresholds": [],
      "timeFrom": null,
      "timeRegions": [],
      "timeShift": null,
      "title": "Total Active, Reactive and Apparent Power",
      "tooltip": {
        "shared": true,
        "sort": 0,
        "value_type": "individual"
      },
      "type": "graph",
      "xaxis": {
        "buckets": null,
        "mode": "time",
        "name": null,
        "show": true,
        "values": []
      },
      "yaxes": [
        {
          "format": "voltamp",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        },
        {
          "format": "watt",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        }
      ],
      "yaxis": {
        "align": false,
        "alignLevel": null
      }
    },
    {
      "aliasColors": {},
      "bars": false,
      "dashLength": 10,
      "dashes": false,
      "datasource": "${DS_PROFICLOUD}",
      "fieldConfig": {
        "defaults": {
          "custom": {},
          "links": []
        },
        "overrides": []
      },
      "fill": 0,
      "fillGradient": 0,
      "gridPos": {
        "h": 8,
        "w": 24,
        "x": 0,
        "y": 36
      },
      "hiddenSeries": false,
      "id": 12,
      "legend": {
        "avg": false,
        "current": false,
        "max": false,
        "min": false,
        "show": true,
        "total": false,
        "values": false
      },
      "lines": true,
      "linewidth": 1,
      "nullPointMode": "null",
      "options": {
        "alertThreshold": true
      },
      "percentage": false,
      "pluginVersion": "7.4.2",
      "pointradius": 2,
      "points": false,
      "renderer": "flot",
      "seriesOverrides": [
        {
          "alias": "PF",
          "yaxis": 2
        }
      ],
      "spaceLength": 10,
      "stack": false,
      "steppedLine": false,
      "targets": [
        {
          "alias": "P",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~P",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        },
        {
          "alias": "S",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~S",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        },
        {
          "alias": "PF",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~PF",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "C",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "thresholds": [],
      "timeFrom": null,
      "timeRegions": [],
      "timeShift": null,
      "title": "Total Active and Apparent Power with Power Factor",
      "tooltip": {
        "shared": true,
        "sort": 0,
        "value_type": "individual"
      },
      "type": "graph",
      "xaxis": {
        "buckets": null,
        "mode": "time",
        "name": null,
        "show": true,
        "values": []
      },
      "yaxes": [
        {
          "format": "voltamp",
          "label": "P, S",
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        },
        {
          "decimals": null,
          "format": "none",
          "label": "Power Factor",
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        }
      ],
      "yaxis": {
        "align": false,
        "alignLevel": null
      }
    },
    {
      "aliasColors": {},
      "bars": false,
      "dashLength": 10,
      "dashes": false,
      "datasource": "${DS_PROFICLOUD}",
      "fieldConfig": {
        "defaults": {
          "custom": {},
          "links": []
        },
        "overrides": []
      },
      "fill": 0,
      "fillGradient": 0,
      "gridPos": {
        "h": 8,
        "w": 24,
        "x": 0,
        "y": 44
      },
      "hiddenSeries": false,
      "id": 6,
      "legend": {
        "alignAsTable": true,
        "avg": true,
        "current": true,
        "max": true,
        "min": true,
        "show": true,
        "total": false,
        "values": true
      },
      "lines": true,
      "linewidth": 1,
      "nullPointMode": "null",
      "options": {
        "alertThreshold": true
      },
      "percentage": false,
      "pluginVersion": "7.4.2",
      "pointradius": 2,
      "points": false,
      "renderer": "flot",
      "seriesOverrides": [],
      "spaceLength": 10,
      "stack": false,
      "steppedLine": false,
      "targets": [
        {
          "alias": "U12",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~U12",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        },
        {
          "alias": "U23",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~U23",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        },
        {
          "alias": "U31",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~U31",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "C",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "thresholds": [
        {
          "colorMode": "custom",
          "fill": false,
          "fillColor": "rgba(50, 116, 217, 0.2)",
          "line": true,
          "lineColor": "#A352CC",
          "op": "gt",
          "value": 400,
          "yaxis": "left"
        }
      ],
      "timeFrom": null,
      "timeRegions": [],
      "timeShift": null,
      "title": "Line-to-Line Voltages",
      "tooltip": {
        "shared": true,
        "sort": 0,
        "value_type": "individual"
      },
      "type": "graph",
      "xaxis": {
        "buckets": null,
        "mode": "time",
        "name": null,
        "show": true,
        "values": []
      },
      "yaxes": [
        {
          "format": "volt",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        },
        {
          "format": "short",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        }
      ],
      "yaxis": {
        "align": false,
        "alignLevel": null
      }
    },
    {
      "aliasColors": {},
      "bars": false,
      "dashLength": 10,
      "dashes": false,
      "datasource": "${DS_PROFICLOUD}",
      "fieldConfig": {
        "defaults": {
          "custom": {},
          "links": []
        },
        "overrides": []
      },
      "fill": 0,
      "fillGradient": 0,
      "gridPos": {
        "h": 8,
        "w": 24,
        "x": 0,
        "y": 52
      },
      "hiddenSeries": false,
      "id": 8,
      "legend": {
        "alignAsTable": true,
        "avg": true,
        "current": true,
        "max": true,
        "min": true,
        "show": true,
        "total": false,
        "values": true
      },
      "lines": true,
      "linewidth": 1,
      "nullPointMode": "null",
      "options": {
        "alertThreshold": true
      },
      "percentage": false,
      "pluginVersion": "7.4.2",
      "pointradius": 2,
      "points": false,
      "renderer": "flot",
      "seriesOverrides": [],
      "spaceLength": 10,
      "stack": false,
      "steppedLine": false,
      "targets": [
        {
          "alias": "U1",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~U1",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        },
        {
          "alias": "U2",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~U2",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        },
        {
          "alias": "U3",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~U3",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "C",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "thresholds": [
        {
          "colorMode": "custom",
          "fill": false,
          "fillColor": "rgba(50, 116, 217, 0.2)",
          "line": true,
          "lineColor": "#A352CC",
          "op": "gt",
          "value": 230,
          "yaxis": "left"
        }
      ],
      "timeFrom": null,
      "timeRegions": [],
      "timeShift": null,
      "title": "Phase Voltages",
      "tooltip": {
        "shared": true,
        "sort": 0,
        "value_type": "individual"
      },
      "type": "graph",
      "xaxis": {
        "buckets": null,
        "mode": "time",
        "name": null,
        "show": true,
        "values": []
      },
      "yaxes": [
        {
          "format": "volt",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        },
        {
          "format": "short",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        }
      ],
      "yaxis": {
        "align": false,
        "alignLevel": null
      }
    },
    {
      "aliasColors": {},
      "bars": false,
      "dashLength": 10,
      "dashes": false,
      "datasource": "${DS_PROFICLOUD}",
      "fieldConfig": {
        "defaults": {
          "custom": {},
          "links": []
        },
        "overrides": []
      },
      "fill": 0,
      "fillGradient": 0,
      "gridPos": {
        "h": 8,
        "w": 24,
        "x": 0,
        "y": 60
      },
      "hiddenSeries": false,
      "id": 14,
      "legend": {
        "alignAsTable": true,
        "avg": true,
        "current": true,
        "max": true,
        "min": true,
        "show": true,
        "total": false,
        "values": true
      },
      "lines": true,
      "linewidth": 1,
      "nullPointMode": "null",
      "options": {
        "alertThreshold": true
      },
      "percentage": false,
      "pluginVersion": "7.4.2",
      "pointradius": 2,
      "points": false,
      "renderer": "flot",
      "seriesOverrides": [],
      "spaceLength": 10,
      "stack": false,
      "steppedLine": false,
      "targets": [
        {
          "alias": "I1",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~I1",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "A",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        },
        {
          "alias": "I2",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~I2",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "B",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        },
        {
          "alias": "I3",
          "groupBy": [
            {
              "params": [
                "$__interval"
              ],
              "type": "time"
            },
            {
              "params": [
                "none"
              ],
              "type": "fill"
            }
          ],
          "measurement": "auto~I3",
          "orderByTime": "ASC",
          "policy": "default",
          "refId": "C",
          "resultFormat": "time_series",
          "select": [
            [
              {
                "params": [
                  "value"
                ],
                "type": "field"
              },
              {
                "params": [],
                "type": "mean"
              }
            ]
          ],
          "tags": [
            {
              "key": "uuid",
              "operator": "=",
              "value": "$uuid"
            }
          ]
        }
      ],
      "thresholds": [],
      "timeFrom": null,
      "timeRegions": [],
      "timeShift": null,
      "title": "Currents",
      "tooltip": {
        "shared": true,
        "sort": 0,
        "value_type": "individual"
      },
      "type": "graph",
      "xaxis": {
        "buckets": null,
        "mode": "time",
        "name": null,
        "show": true,
        "values": []
      },
      "yaxes": [
        {
          "format": "amp",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        },
        {
          "format": "short",
          "label": null,
          "logBase": 1,
          "max": null,
          "min": null,
          "show": true
        }
      ],
      "yaxis": {
        "align": false,
        "alignLevel": null
      }
    }
  ],
  "refresh": "10s",
  "schemaVersion": 27,
  "style": "dark",
  "tags": [],
  "templating": {
    "list": [
      {
        "allValue": null,
        "current": {},
        "datasource": "${DS_PROFICLOUD}",
        "definition": "SHOW UUIDS",
        "description": null,
        "error": null,
        "hide": 0,
        "includeAll": false,
        "label": "UUID:",
        "multi": false,
        "name": "uuid",
        "options": [],
        "query": "SHOW UUIDS",
        "refresh": 1,
        "regex": "",
        "skipUrlSync": false,
        "sort": 0,
        "tagValuesQuery": "",
        "tags": [],
        "tagsQuery": "",
        "type": "query",
        "useTags": false
      },
      {
        "allValue": null,
        "current": {
          "tags": [],
          "text": "1h",
          "value": "1h"
        },
        "description": null,
        "error": null,
        "hide": 0,
        "includeAll": false,
        "label": "Time range",
        "multi": false,
        "name": "timerange",
        "options": [
          {
            "selected": true,
            "text": "1h",
            "value": "1h"
          },
          {
            "selected": false,
            "text": "1w",
            "value": "1w,4d"
          }
        ],
        "query": "1h, 1w",
        "skipUrlSync": false,
        "type": "custom"
      }
    ]
  },
  "time": {
    "from": "now-6h",
    "to": "now"
  },
  "timepicker": {
    "refresh_intervals": [
      "10s",
      "30s",
      "1m",
      "5m",
      "15m",
      "30m",
      "1h",
      "2h",
      "1d"
    ]
  },
  "timezone": "",
  "title": "EMpro Template",
  "uid": "empro_template",
  "version": 11
}

Some organizations have premade templates. These are accessed by clicking the “Device Template” button.
Some organizations have premade templates. These are accessed by clicking the “Device Template” button.

Please check the organization you are in by looking at the user profile on the sidebar: The default TSD organization “PROFICLOUD”, which we use to provide you some default templates for your devices, has read-only access.

To take a look at those, please click on the grey dashboard button on the left side and select “manage”.

You can see an overview of the different default templates we currently offer.

Select one of them to see what they look like. After you’ve selected a dashboard you can change the UUID of the device you’re looking at in the top left corner.

There you can see basic information about your devices and check if they are running. These premade templates can’t be edited or removed.

To export the data shown in a particular panel of a dashboard, just click on the panel title and select the “Export CSV” option.

Where to find the
Navigating to the export csv option

You will be presented with a couple of options for the CSV export such as the mode and format of the timestamp. Once you have chosen your settings, click “Export” and the CSV file will be generated for you.

CSV export options
CSV export options

Our cloud system delivers data to your browser where the data is rendered and displayed. We limit the maximum number of data points for each query to 20000 points. Please note, that querying more data points for a single query is not providing much information, because your screen resolution likely does not have the resolution to display all of the data anyway. The limitation keeps processing time in the browser in check and results in a more snappy response of the user side.

If you want to view a larger time range, where you would end up with more than 20000 data points, we recommend you have a look at the grouping and aggregation parameters for the queries. Our template dashboards do this by default. You can choose a grouping interval to suit your needs, but it usually suffices to use the “$__interval” range. This will take the selected time range, your screen resolution and size of the panel into account and our database will aggregate the data for you. You can choose different aggregation options through the query editor. The benefit of this is, that the load is shifted to our cloud system and the amount of data which must be transferred to your browser is reduced. This also results in much smaller workload for your browser resulting in a better user experience. Have a look at the following screenshot for an example:

Aggregation and grouping options

Time Series Data Service – Alerting

Why is there a difference between the time shown in the Time Series Data Service and the Time Series Data Alerting?

The times of the data sent by the device must be sent in the UTC format. For this purpose the hardware clock must be set to UTC so that the values get the correct time stamp.

Configuration options for the Time Series Data Service and the associated alerting.
  1. Navigate to the panel you want to add or edit an alert rule for, click the title, and then click [Edit].
  2. On the Alert tab, click [Create Alert]. If an alert already exists for this panel, then you can just edit the fields on the Alert tab.
  3. Fill out the fields.
    1. Name: Enter a descriptive name. The name will be displayed in the Alert Rules list.
    2. Evaluate every: Specify how often the scheduler should evaluate the alert rule.
    3. For: Specify for how long the query needs to violate the configured thresholds before the alert notification triggers
  4. Now choose your conditions, specify a query
    1. When: Controls how the values for each series are reduced to a value that can be compared against the threshold. Click on the function to change it to another function.
    2. Of: Specify a time range. The letter defines what query to execute from the Query tab. “(A,5m,now)” means 5 minutes ago to now. You can also do ”(A,10m,now-2m)” to define a time range that will be 10 minutes ago to 2 minutes ago.
    3. Is Above: Defines the type pf threshold and the threshold value. You can click to change the type of threshold.
  5. You can now set the ways of how you want to be notified in the “Notifications” area.
    1. With a Click on the [ + ] right next to “Send to” you can chose a notification way
    2. Fill in the message you want to get in case a threshold is violated.
    3. Tags: Specify a list of tags to be included in the notification
  1. When you have finished writing your rule click “save dashboard” in the upper right corner to save the alert rule and the dashboard.
  2. (optional) Click “Test rule” to make sure the rule returns the results you expect.

Time Series Data Alerting allows you to receive notifications of certain threshold violations in the Time Series Data Service. You can also receive these messages when you are not actively working in the Time Series Data Service, for example, by email or messenger.

You can create alerts so you get notifications when a certain rule is fulfilled, for example you could get an email when your device’s temperature is above 64 degrees.

  1. Open the Time Series Data Service and navigate to the “Notification channels” with a click on the “bell” in the left side navigation
  2. Click on [New channel] to set up a new notification channel.
  3. Here you have to fill in some settings:
    1. Name: Enter a descriptive name, the name will be displayed when you create a new Alert rule and choose a notification
    2. Type: Choose how the notification should be sent, for example Email, Slack, Microsoft Teams …
    3. Default:  Use this notification for all alerts
    4. Include Image: Captures an image and include it in the notification
    5. Disable Resolve Message: Disable the resolve message [OK] that is sent when alerting state returns to false
    6. Send reminders:  Send additional notifications for triggered alerts

As a reminder you can hover over the “i” symbol to receive more information

(optional): to test if the notification gets send to you click “Send Test” on the bottom.

  1. Navigate to the panel within your dashboard using the appropriate alert.
  2. Click the name of the panel, and click [Edit].
  3. Click on the “bell” on the left side of the setting options to get to your configured alerts.
  4. Click [Delete] in the upper right corner of the setting area.
  5. Confirm the deletion with a click on [Delete] – The Panel will still be available you are only deleting the alarm.