Skip to main content

​
Overview

The Analytics Engine lets you create interactive dashboards with drag-and-drop widgets. Visualize your data with charts, tables, metrics, and more.

​
Dashboard Features

​
Widget Types

Create visualizations using various 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

Each widget type has specific options: Chart Options:
  • X-axis and Y-axis fields
  • Color schemes
  • Legend position
  • Axis labels and formatting
Table Options:
  • 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

Each widget is powered by a SQL query: 
-- 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

Start simple: Begin with a few key metrics before adding complex visualizations
Use consistent colors: Maintain a color scheme across related charts
Optimize queries: Use aggregations and filters to keep dashboards fast