data-visualization-toollisted

# Data Visualization — DBX Studio ## Chart Types Available The `generate_chart` tool supports these types: | Type | Best For | |------|----------| | `bar` | Comparisons between categories | | `line` | Trends over time | | `pie` | Part-to-whole relationships (< 7 slices) | | `scatter` | Correlation between two numeric values | | `area` | Cumulative trends over time | | `histogram` | Distribution of a numeric column | ## Workflow 1. Understand what the user wants to visualize 2. Write the SQL query to get the data (`data_query`) 3. Call `generate_chart` with the config 4. Confirm chart title and axes are meaningful ## generate_chart Parameters ```json { "chart_type": "bar", "title": "Monthly Revenue by Product Category", "x_axis": "category", "y_axis": "revenue", "data_query": "SELECT category, SUM(amount) AS revenue FROM orders GROUP BY 1 ORDER BY 2 DESC", "group_by": "category" } ``` ## Chart Selection Guide **User says "trend" or "over time"** → `line` chart, x_axis = date column **User says "compare" or "by category"** → `bar` chart **User says "breakdown" or "share"** → `pie` chart (only if ≤ 7 categories) **User says "distribution" or "spread"** → `histogram` **User says "relationship" or "correlation"** → `scatter` ## Data Query Patterns ### Bar: Top N categories ```sql SELECT category, COUNT(*) AS count FROM orders GROUP BY category ORDER BY count DESC LIMIT 10 ``` ### Line: Time series ```sql SELECT DATE_TRUNC('day', created_at) AS date, SUM(amo