{
        "dataSource": "/api/reports/revenue-by-product/:orgId",
        "autoRefresh": 120000,
        "pagination": {
            "enabled": true,
            "pageSize": 25,
            "pageSizes": [10, 25, 50, 100]
        },
        "columns": [
            {
                "field": "product_name",
                "label": "Product/Service",
                "sortable": true,
                "searchable": true,
                "width": "20%",
                "render": "link",
                "linkAction": "reports:view-product-details"
            },
            {
                "field": "category",
                "label": "Category",
                "sortable": true,
                "width": "12%",
                "render": "badge",
                "badgeColor": "info"
            },
            {
                "field": "total_revenue",
                "label": "Total Revenue",
                "sortable": true,
                "width": "12%",
                "format": "currency",
                "align": "right"
            },
            {
                "field": "revenue_ytd",
                "label": "Revenue YTD",
                "sortable": true,
                "width": "12%",
                "format": "currency",
                "align": "right"
            },
            {
                "field": "quantity_sold",
                "label": "Qty Sold",
                "sortable": true,
                "width": "8%",
                "format": "number",
                "align": "center"
            },
            {
                "field": "times_sold",
                "label": "Times Sold",
                "sortable": true,
                "width": "8%",
                "format": "count",
                "align": "center"
            },
            {
                "field": "avg_selling_price",
                "label": "Avg Price",
                "sortable": true,
                "width": "10%",
                "format": "currency",
                "align": "right"
            },
            {
                "field": "unique_customers",
                "label": "Customers",
                "sortable": true,
                "width": "8%",
                "format": "count",
                "align": "center"
            },
            {
                "field": "last_sale_date",
                "label": "Last Sale",
                "sortable": true,
                "width": "10%",
                "format": "date"
            }
        ],
        "filters": [
            {
                "field": "category",
                "label": "Category",
                "type": "select",
                "options": [
                    {"value": "", "label": "All Categories"},
                    {"value": "Product", "label": "Products"},
                    {"value": "Service", "label": "Services"}
                ],
                "default": ""
            },
            {
                "field": "is_active",
                "label": "Status",
                "type": "select",
                "options": [
                    {"value": "", "label": "All"},
                    {"value": "true", "label": "Active"},
                    {"value": "false", "label": "Inactive"}
                ],
                "default": ""
            },
            {
                "field": "min_revenue",
                "label": "Min Revenue",
                "type": "number",
                "placeholder": "0.00"
            },
            {
                "field": "search",
                "label": "Search",
                "type": "text",
                "placeholder": "Search product/service..."
            }
        ],
        "rowActions": [
            {
                "label": "View Details",
                "icon": "fa-eye",
                "action": "reports:view-product-details",
                "color": "info"
            },
            {
                "label": "Sales History",
                "icon": "fa-history",
                "action": "reports:drill-down-product-sales",
                "color": "primary"
            },
            {
                "label": "Customer Analysis",
                "icon": "fa-users",
                "action": "reports:analyze-product-customers",
                "color": "accent"
            },
            {
                "label": "Export Product Report",
                "icon": "fa-file-export",
                "action": "reports:export-product-csv",
                "color": "secondary"
            }
        ],
        "bulkActions": [
            {
                "label": "Export Selected",
                "icon": "fa-file-csv",
                "action": "reports:export-selected-csv",
                "color": "secondary"
            },
            {
                "label": "Compare Products",
                "icon": "fa-code-compare",
                "action": "reports:compare-products",
                "color": "info"
            },
            {
                "label": "Bulk Categorize",
                "icon": "fa-tags",
                "action": "reports:bulk-categorize",
                "color": "warning"
            }
        ],
        "summaryWidgets": [
            {
                "id": "total-product-revenue",
                "type": "stat",
                "title": "Total Revenue",
                "icon": "fa-dollar-sign",
                "color": "success",
                "dataPath": "totals.total_revenue",
                "format": "currency"
            },
            {
                "id": "product-count",
                "type": "stat",
                "title": "Products/Services",
                "icon": "fa-box",
                "color": "info",
                "dataPath": "totals.product_count",
                "format": "count"
            },
            {
                "id": "total-qty-sold",
                "type": "stat",
                "title": "Total Quantity Sold",
                "icon": "fa-shopping-cart",
                "color": "primary",
                "dataPath": "totals.total_quantity",
                "format": "number"
            },
            {
                "id": "best-seller",
                "type": "stat",
                "title": "Best Seller",
                "icon": "fa-star",
                "color": "warning",
                "dataPath": "totals.best_seller_name",
                "subtitle": {
                    "dataPath": "totals.best_seller_revenue",
                    "format": "currency"
                }
            }
        ],
        "exportOptions": [
            {
                "label": "Export to CSV",
                "action": "reports:export-csv",
                "icon": "fa-file-csv",
                "params": {"reportType": "revenue-by-product"}
            },
            {
                "label": "Export to PDF",
                "action": "reports:export-pdf",
                "icon": "fa-file-pdf",
                "params": {"reportType": "revenue-by-product"}
            }
        ]
    }