Charts, tables, crosstabs
Bar, line and pie charts from report rows, table elements for nested lists, and crosstabs with row and column totals.
A chart takes rows from its scope (or any array from source), a category per row and one or more series. groupSum() turns rows into totals per key. A table element lists an array inside a band (the items of each invoice); a crosstab tabulates rows × columns with totals. Charts demo · Crosstab demo
{ "type": "chart", "x": 0, "y": 16, "w": 110, "h": 60, "chartType": "bar", "title": "지역별 매출",
"source": "groupSum(rows, 'region', 'amount')", "category": "region",
"series": [{ "expr": "amount", "label": "매출" }], "format": "#,##0" },
{ "type": "table", "x": 0, "y": 20, "w": 180, "h": 20, "source": "items", "altBackground": "#fafbfd",
"columns": [{ "header": "품목", "expr": "name" }, { "header": "수량", "expr": "qty", "width": 20, "align": "right" },
{ "header": "금액", "expr": "qty * price", "width": 40, "format": "#,##0", "sum": true }] },
{ "type": "crosstab", "x": 0, "y": 0, "w": 180, "h": 50, "rowKey": "region", "columnKey": "category",
"value": "amount", "aggregate": "sum", "format": "#,##0", "corner": "지역 / 품목군" }