Creating charts
Using natural language
- Click “Add chart” on a dashboard or create a standalone chart
- Describe what you want to see, for example:
- “Show me daily user signups over the last 30 days”
- “Display revenue by product category as a pie chart”
- “Create a bar chart of top 10 customers by order value”
- Basedash AI will:
- Write the appropriate SQL query
- Choose the best visualization type
- Apply suitable formatting and styling
How AI chooses chart types
- Data type analysis: Detects dates, numbers, and categories
- Query intent: Understands trends, comparisons, proportions, and conversions
- Data volume: Considers number of points and categories
- Best practices: Applies visualization best practices automatically
- SQL generation: Creates the SQL needed to fetch your data
Chart types
Data visualization charts
- Line charts – Trends and patterns over time
- Timebar charts – Time-based bar visualizations
- Horizontal bar charts – Non-time categorical comparisons
- Pie charts – Proportions and parts of a whole
- Funnel charts – Conversion analysis and flow
Data display components
- Tables – Detailed tabular data display
- Number displays – Single metric values
- Text components – Text and narrative content
- Detail charts – Detailed information panels
Specialized visualizations
- Activity charts – Activity patterns and heatmaps
- Map visualizations – Geographic data display
- Image charts – Image content presentation
Requesting specific chart types
- “Show me monthly revenue as a line chart”
- “Create a pie chart of sales by region”
- “Display customer satisfaction scores as a horizontal bar chart”
- “Show conversion rates in a funnel chart”
- “Display total revenue as a number”
- “Show me user activity patterns as an activity chart”
Adding breakdowns
Use the “broken down by” syntax to create multiple series:- “Show me user signups broken down by email domain”
- “Display sales broken down by product category”
- “Create a chart of visitors broken down by page”
- “Show me revenue over time broken down by region”
Customizing charts
Visual customization
- Adjust axis labels and ranges
- Change colors and themes
- Modify chart titles and descriptions
- Configure legends and formatting (currency, percentages, etc.)
Data customization
- Edit the underlying SQL query
- Change aggregation methods
- Add calculated fields
- Filter data points
- Sort and limit results
Advanced SQL editing
AI handles most query needs, but you can always edit the SQL powering any chart for full control. For complex queries, use the SQL editor.Best practices
Choose based on your goal
- Trends over time: Line charts, timebar charts
- Comparisons: Horizontal bar charts
- Proportions: Pie charts
- Conversions: Funnel charts
- Single metrics: Number displays
- Activity patterns: Activity charts
- Geographic data: Map visualizations
Consider your data
- Small datasets (< 10 categories): Pie charts work well
- Large datasets (> 20 categories): Horizontal bar charts are better
- Time series: Use line charts for continuous trends
- Categorical data: Use horizontal bar charts
Design for clarity
- Keep charts simple and focused
- Use clear, descriptive titles
- Add context with descriptions
- Choose appropriate time ranges