Building Dashboards

• Creating Dashboards
  • Dashboard Builder
  • Widget Types
  • Filters
  • Auto-Refresh
• Customisation
  • Layout
  • Styling

Creating Dashboards

Dashboard Builder

1. Navigate to Dashboards → New Dashboard
2. Name: “Device Monitoring”
3. Add widgets from palette
4. Configure data sources
5. Customise layout
6. Save and publish

   Widget Types

Numeric Cards:

1
2
3
SELECT COUNT(DISTINCT device_id) as total_devices
FROM iot_catalog.devices
WHERE status = 'active';

Line Charts:

1
2
3
4
5
6
7
SELECT 
  DATE_TRUNC('hour', timestamp) as hour,
  AVG(temperature) as avg_temp
FROM iot_catalog.telemetry
WHERE timestamp > current_timestamp() - INTERVAL 24 HOURS
GROUP BY hour
ORDER BY hour;

Bar Charts:

1
2
3
4
5
6
SELECT
device_type,
COUNT(*) as count
FROM iot_catalog.devices
GROUP BY device_type
ORDER BY count DESC;

Tables:

1
2
3
4
5
6
7
8
9
SELECT
device_name,
temperature,
humidity,
timestamp
FROM iot_catalog.telemetry
WHERE timestamp > current_timestamp() - INTERVAL 1 HOUR
ORDER BY timestamp DESC
LIMIT 100;

Filters

Dashboard-Level Filters:

• Date range picker
• Device selector
• Location filter
• Custom filters

Example:

1
2
3
4
SELECT *
FROM iot_catalog.telemetry
WHERE device_id = ''
AND timestamp BETWEEN '' AND '';

Auto-Refresh

Configuration:

• Refresh interval: 30s, 1m, 5m, 15m, 30m, 1h
• Auto-refresh on filter change
• Manual refresh button

Customisation

Layout

• Drag and drop widgets
• Resize widgets
• Grid alignment
• Responsive design

Styling

• Colour schemes
• Fonts and sizes
• Widget borders
• Background colours