Track KPIs and Create Interactive Dashboards in Zerynth Cloud¶
Dashboard is the interface the user uses to interact with the IoT solution. It enables clear visualization of key KPIs on the solution and enables control over fleets of devices. Zerynth makes it easy to control devices, monitor industrial sensors and machines, and generate reports through our integrated dashboard service. In this tutorial, We will create our first dashboard in Zerynth Cloud, We will create a basic template with 1 panel to visualize data, Feel free to customize the template according to your application.
Activate Zerynth Dashboard¶
The first step is to enable the Zerynth Dashboard service in your workspace, Inside your workspace, click on “Zerynth Dashboard” section in the left bar.

Enable the dashboard service by clicking “Enable Zerynth Dashboard” button.

Create a new Layout¶
Inside the dashboard section, Click on “+” and then on “Dashboard”.
Create a new panel by clicking on “Add an empty panel".

On the right, there are some settings about the panel such as panel name, panel type, and other settings that depend on the active panel. On the left side, you can make a query to get data to visualize. You can write a query using “Query builder” or write an SQL raw query. Initially, you are in “Query builder” mode, but by clicking on “Edit SQL” you switch to raw query mode.

Here's an example of an SQL raw query with the “Time series” panel type.
SELECT
ts_device as time,
(payload->>'temp')::float as temp
FROM data
ORDER BY ts_device

Click on the “Save” button on the top right to save the dashboard.
SQL Query¶
through SQL queries you can get data or conditions.
Data queries¶
To get data, you need to put “data” after “FROM”, and you can use the following columns.
Name | Type | Description |
---|---|---|
ts_device | time | Timestamp corresponding to when the data has been sent by device |
ts_zdm | time | Timestamp corresponding to when the data has arrived on ZDM |
ts_db | time | Timestamp corresponding to when the data has been save on database |
workspace_id | string | Workspace id of the device |
fleet_id | string | Fleet id of the device |
device_id | string | Id of the device |
tag | string | Publication tag with whom the data has been sent by device |
payload | jsonb | Payload published by device |
Condition queries¶
To get conditions, you need to put “conditions” after “FROM”, and you can use the following columns.
Name | Type | Description |
---|---|---|
Id | string | Id of the condition |
tag | string | Publication tag with whom the data has been sent by device |
workspace_id | string | Workspace id of the device |
fleet_id | string | Fleet id of the device |
device_id | string | Id of the device |
payload | jsonb | Payload published by device when the condition has been opened |
payloadf | jsonb | Payload published by device when the condition has been closed |
start | time | Timestamp that indicates when the condition has been opened |
finish | time | Timestamp that indicates when the condition has been closed |
More information¶
In simple steps, we have created our template in Zerynth dashboard. If you have any questions, Please drop us a message on our Helpdesk.