{
"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","ZH",11580,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=canton&value=ZH"],["Click a bar to see the rows behind it","BE",5195,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=canton&value=BE"],["Click a bar to see the rows behind it","VD",5170,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=canton&value=VD"],["Click a bar to see the rows behind it","FR",5015,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=canton&value=FR"],["Click a bar to see the rows behind it","AG",3960,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=canton&value=AG"],["Click a bar to see the rows behind it","BS",3615,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=canton&value=BS"],["Click a bar to see the rows behind it","LU",3395,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=canton&value=LU"],["Click a bar to see the rows behind it","SG",3180,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=canton&value=SG"],["Click a bar to see the rows behind it","TI",2350,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=canton&value=TI"],["Click a bar to see the rows behind it","GE",1735,null,null,"rows.sql?m=revenue_finance&period=2026-09&dim=canton&value=GE"]]
}
The SQL behind this page
select canton, sum(invoice_amount_chf)
from leads
where invoiced_at >= '2026-09-01' and invoiced_at < '2026-10-01' -- Europe/Zurich
group by canton
order by 2 desc;