Analytics Engine

​

Overview

​

Dashboard Features

​

Widget Types

• Line Charts: Track trends over time
• Bar Charts: Compare categories
• Pie Charts: Show proportions
• Area Charts: Display cumulative values
• Scatter Plots: Analyze correlations
• Data Tables: Show detailed records
• Metric Cards: Display KPIs

​

Drag-and-Drop Layout

• Resize widgets to any size
• Arrange widgets in a flexible grid
• Create multi-column layouts
• Save and share dashboards

​

Creating a Dashboard

​

Step 1: Create New Dashboard

1. Navigate to Analytics Engine
2. Click New Dashboard
3. Give your dashboard a name

​

Step 2: Add Widgets

1. Click Add Widget
2. Select your widget type
3. Write or select a query for the data
4. Configure chart options

​

Step 3: Configure Visualization

• X-axis and Y-axis fields
• Color schemes
• Legend position
• Axis labels and formatting

• Column selection
• Sorting
• Pagination
• Search and filter

​

Step 4: Save and Share

• Save your dashboard
• Share with team members
• Set refresh intervals for live data

​

Query-Powered Widgets

-- Revenue by month for line chart
SELECT
  DATE_TRUNC('month', order_date) as month,
  SUM(total) as revenue
FROM orders
WHERE order_date >= '2024-01-01'
GROUP BY month
ORDER BY month;

​

Best Practices