Time Series Data Service FAQs
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 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.
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.
- Click on [+] symbol on the left side of your screen, then on [Dashboard]
- Click on [Add Query] to start creating your new dashboard
- Select your data source from the dropdown right next to “Query”
- Build your query using the graphical editor
- Start by selecting a UUID in the “FROM”-row with clicking on the [+] right next to “where”
- Now select one of your UUIDs with a click on [select tag value]
- In the “FROM”-row, click now on [select measurement] so select what data should be displayed in your dashboard
- In the “SELECT”-row you now can change the field of the data inside the graph with clicking on the [+] next to “mean”
- In the “GROUP BY”-row you can set the interval of the data inside the graph
- You can give your data a new alias, with typing in a name in the row “ALIAS BY”
- 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
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.
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.
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.
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.
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.
If you want, you can add a description, it supports markdown and links.
Exporting data from the Time Series Data Service as a CSV file is very simple.
Open any dashboard in which you can find a panel with the corresponding data. If you have not yet created your own dashboards, you can also use the Device Template.
Navigate to the panel with the data (metric) you want to export. Here, click on the name of the panel to open the context menu. Here, click on “Inspect” and then on “Data”.
Here you can export the data as a CSV file. The data displayed will always be exported, so if you want a different time period than the one initially set, you must change the time period before exporting.
The template dashboards can not be modified. Every modification you make here, will be revoked after a reload of the page.
You can export the templates and import them as your own custom dashboard, where you can also apply changes.
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:
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.
- Navigate to the panel you want to add or edit an alert rule for, click the title, and then click [Edit].
- 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.
- Fill out the fields.
- Name: Enter a descriptive name. The name will be displayed in the Alert Rules list.
- Evaluate every: Specify how often the scheduler should evaluate the alert rule.
- For: Specify for how long the query needs to violate the configured thresholds before the alert notification triggers
- Now choose your conditions, specify a query
- 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.
- 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.
- Is Above: Defines the type pf threshold and the threshold value. You can click to change the type of threshold.
- You can now set the ways of how you want to be notified in the “Notifications” area.
- With a Click on the [ + ] right next to “Send to” you can chose a notification way
- Fill in the message you want to get in case a threshold is violated.
- Tags: Specify a list of tags to be included in the notification
- Navigate to the panel within your dashboard using the appropriate alert.
- Click the name of the panel, and click [Edit].
- Click on the “bell” on the left side of the setting options to get to your configured alerts.
- Click [Delete] in the upper right corner of the setting area.
- Confirm the deletion with a click on [Delete] – The Panel will still be available you are only deleting the alarm.
- Open the Time Series Data Service and navigate to the “Notification channels” with a click on the “bell” in the left side navigation
- Click on [New channel] to set up a new notification channel.
- Here you have to fill in some settings:
- Name: Enter a descriptive name, the name will be displayed when you create a new Alert rule and choose a notification
- Type: Choose how the notification should be sent, for example Email, Slack, Microsoft Teams …
- Default: Use this notification for all alerts
- Include Image: Captures an image and include it in the notification
- Disable Resolve Message: Disable the resolve message [OK] that is sent when alerting state returns to false
- 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.
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.
Because the data points that are uploaded have a certain resolution. In the end it’s a group of single data points. You can change the way it’s displayed in the visualization possibilities of the graph. Set Null value on the very right to “connected”.
If the “Evaluate every” and the “For” time have the same value, the alert may not be triggered until after the second cycle. This can be changed if the “For” value is set to a different value (e.g. 30s).
If you want to show average values in the Time Series Data Service, for example, you must specify from which group of data points this should be done. By default, the function is set to “Group by Time Period”, so you can start directly.