The visual builder lets you construct data queries without writing code:
| Component | What It Does |
|---|---|
| Table Relations | Select which data tables to query |
| Joins | Connect related tables for cross-data analysis |
| Aggregations | Apply SUM, COUNT, AVG, MIN, MAX to fields |
| Group By | Group results by specific dimensions |
| Order By | Sort results ascending or descending |
| Limit | Cap the number of results returned |
For advanced users:
> Tip: AI-assisted query generation is the fastest way to build widgets. Start with natural language, then refine the generated query in SQL mode if needed.
Select from 14+ visualization types:
| Chart Type | Best For |
|---|---|
| Bar Chart | Comparing categories |
| Line Chart | Trends over time |
| Pie Chart | Distribution/proportions |
| Donut Chart | Distribution with center metric |
| Area Chart | Volume over time |
| Scatter Plot | Correlation analysis |
| Table | Detailed data display |
| Number/KPI | Single key metric |
| Gauge | Progress toward a target |
| Heatmap | Density/intensity patterns |
| Radar | Multi-dimensional comparison |
| Treemap | Hierarchical data |
| Funnel | Sequential process metrics |
| Stacked Bar | Category composition |
Interno includes 14+ pre-built KPI widgets:
| Issue | Solution |
|---|---|
| No data in widget | Verify your integrations are connected and syncing. Check the query targets the correct data tables. |
| SQL query fails | Check syntax. Use the visual builder to validate the correct table and column names. |
| AI-generated query is incorrect | Refine your prompt with more specific details. Review and edit the generated SQL. |
| Cannot save dashboard | Ensure you have Dashboard Edit permission. Check for unsaved widget configurations. |