# Simple detail report from CSV
python src/report_generator.py --source examples/sample_data.csv --format markdown

# Group by department with aggregated metrics
python src/report_generator.py --source examples/sample_data.csv \
    --group-by department \
    --metrics "revenue:sum,revenue:avg,deals_closed:sum,satisfaction:avg" \
    --sort "revenue_sum:desc" \
    --title "Department Summary"

# Full report from a JSON config file
python src/report_generator.py --config examples/report_generator_config.json

# HTML report written to a file
python src/report_generator.py --source examples/sample_data.csv \
    --group-by department --metrics "revenue:sum" \
    --format html --output department_report.html

# Filter rows before aggregating
python src/report_generator.py --source examples/sample_data.csv \
    --filter "region:eq:North" \
    --group-by department --metrics "revenue:sum"

{
    "title": "Q1 Performance Report — AcmeCorp",
    "description": "Quarterly departmental performance summary.",
    "source": {
        "type": "csv",
        "path": "examples/sample_data.csv"
    },
    "filters": [
        {"field": "hours_worked", "op": "gte", "value": 155}
    ],
    "computed_columns": [
        {"name": "revenue_per_hour", "expression": "revenue / hours_worked"}
    ],
    "group_by": ["department"],
    "metrics": [
        {"field": "revenue", "agg": "sum"},
        {"field": "revenue", "agg": "avg"},
        {"field": "deals_closed", "agg": "sum"},
        {"field": "satisfaction", "agg": "avg"}
    ],
    "sort": [{"field": "revenue_sum", "order": "desc"}],
    "output": {"format": "markdown"},
    "charts": true
}