{
"type": "bar",
"time": null,
"labels": true,
"marker": null,
"xtitle": null,
"ytitle": null,
"ztitle": null,
"xticks": null,
"yticks": null,
"ystep": null,
"xmin": null,
"ymin": null,
"xmax": null,
"ymax": null,
"toolbar": null,
"show_legend": false,
"logarithmic": null,
"horizontal": true,
"stacked": null,
"height": 360,
"colors": [],
"points": [["Click a bar to see the rows behind it","Basic health (KVG)",23055,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=product&value=Basic%20health%20%28KVG%29"],["Click a bar to see the rows behind it","Life",9770,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=product&value=Life"],["Click a bar to see the rows behind it","Supplementary (VVG)",9540,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=product&value=Supplementary%20%28VVG%29"],["Click a bar to see the rows behind it","Car",2830,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=product&value=Car"]]
}
The SQL behind this page
select product, sum(invoice_amount_chf)
from leads
where invoiced_at >= '2026-09-01' and invoiced_at < '2026-10-01' -- Europe/Zurich
group by product
order by 2 desc;