Charts & Visualizations
Aicser renders charts using Apache ECharts. Charts are created from data source queries and can be saved, customized, and added to dashboards.
Chart types
Aicser supports over 30 chart types, including:
Basic
- Bar chart (vertical and horizontal)
- Line chart
- Area chart
- Pie and donut chart
- Scatter plot
Statistical
- Box plot
- Heatmap
- Histogram
- Funnel chart
Advanced
- Candlestick chart
- Gauge chart
- Radar chart
- Sankey diagram
- Tree map
Table
- Data table with sorting and pagination
Creating a chart
- Go to Charts and click New Chart
- Select a data source
- Write a SQL query, or in EE ask a question in natural language
- Select a chart type from the right panel
- Configure axes, colors, and labels in the Options panel
- Click Save
Customization
- Axis labels and titles — customize labels on each axis
- Color scheme — preset palettes or custom colors
- Legend — toggle and position the legend
- Tooltip — configure hover content
- Data labels — show values directly on chart elements
Chart queries
Charts are driven by SQL queries executed against your connected data sources. Aicser maps result columns to chart axes automatically when possible.
In EE, natural language questions are translated to SQL before execution — see Natural Language Queries.