Creating Dashboards

Dashboards turn your raw telemetry into visual answers. Use them to monitor equipment health, track KPIs, and spot trends that matter to your operation.

After reading this page, you will be able to:

• Create a new dashboard and add widgets
• Write ClickHouse SQL queries to bind live data to widgets
• Configure visual thresholds (color ranges) for gauges and charts
• Export and import dashboards between environments

How Dashboards Work

Dashboards in Proxus are query-driven. Each widget runs a ClickHouse SQL query and refreshes on a configurable interval (or manually). This means dashboards display periodic snapshots of your data, not a continuous real-time stream.

Creating Your First Dashboard

Open the dashboard list

Navigate to Visualization > Dashboards and click New Dashboard. Give it a descriptive name like "Production Line Monitor."

Add a Gauge widget

Drag a Gauge from the widget toolbox onto the canvas. This will show a single value — perfect for current Temperature or Speed.

Write the data query

Click the Gauge to open its properties panel. Under Data Source, select New SQL Query and enter:

content_copy check

SELECT 
  avg(Value) as Temperature
FROM DeviceRawData
WHERE TagName = 'Temperature'
  AND DeviceName = 'Gen_01'
  AND Time > now() - INTERVAL 5 MINUTE

This query calculates the average Temperature from the last 5 minutes. If you followed the Quick Start guide, replace Gen_01 with the device name you created.

Configure the appearance

Set the gauge properties:

• Min: 20
• Max: 80
• Label: Temperature (°C)

Add color ranges so operators can spot problems at a glance:

• 🟢 Green: 20–50 (normal operating range)
• 🟡 Yellow: 50–65 (elevated, monitor closely)
• 🔴 Red: 65–80 (critical, take action)

Set auto-refresh

In the dashboard toolbar, set Auto-Refresh to 10 seconds. The gauge will re-run the SQL query at this interval.

Widget Types

Useful ClickHouse Queries

These queries work with the default DeviceRawData table.

Average value per hour

SELECT 
  toStartOfHour(Time) as Hour,
  avg(Value) as AvgTemperature
FROM DeviceRawData
WHERE TagName = 'Temperature'
  AND DeviceName = 'Gen_01'
  AND Time > now() - INTERVAL 24 HOUR
GROUP BY Hour
ORDER BY Hour

Min / Max over a period

SELECT 
  min(Value) as MinTemp,
  max(Value) as MaxTemp,
  avg(Value) as AvgTemp
FROM DeviceRawData
WHERE TagName = 'Temperature'
  AND Time > now() - INTERVAL 1 HOUR

Device reading count per day

SELECT 
  toDate(Time) as Day,
  DeviceName,
  count() as ReadingCount
FROM DeviceRawData
WHERE Time > now() - INTERVAL 7 DAY
GROUP BY Day, DeviceName
ORDER BY Day DESC, ReadingCount DESC

Downtime detection (no readings for 10+ minutes)

SELECT 
  DeviceName,
  max(Time) as LastReading,
  dateDiff('minute', max(Time), now()) as MinutesSinceLastReading
FROM DeviceRawData
GROUP BY DeviceName
HAVING MinutesSinceLastReading > 10
ORDER BY MinutesSinceLastReading DESC

Binding Options

Sharing Dashboards Between Environments

Dashboards are stored as XML definitions. You can export and import them to share between environments (e.g., Dev → Staging → Production).

To export: Open a dashboard, click the Export button in the toolbar.

To import: In the dashboard list, click Import and select the XML file.

Common Issues and Solutions

For more detailed troubleshooting, see Dashboard Issues.