{
"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",53,null,null,"rows.sql?m=leads_invoiced_finance&period=2026-09&dim=canton&value=ZH"],["Click a bar to see the rows behind it","VD",26,null,null,"rows.sql?m=leads_invoiced_finance&period=2026-09&dim=canton&value=VD"],["Click a bar to see the rows behind it","AG",20,null,null,"rows.sql?m=leads_invoiced_finance&period=2026-09&dim=canton&value=AG"],["Click a bar to see the rows behind it","FR",20,null,null,"rows.sql?m=leads_invoiced_finance&period=2026-09&dim=canton&value=FR"],["Click a bar to see the rows behind it","BE",20,null,null,"rows.sql?m=leads_invoiced_finance&period=2026-09&dim=canton&value=BE"],["Click a bar to see the rows behind it","LU",14,null,null,"rows.sql?m=leads_invoiced_finance&period=2026-09&dim=canton&value=LU"],["Click a bar to see the rows behind it","BS",13,null,null,"rows.sql?m=leads_invoiced_finance&period=2026-09&dim=canton&value=BS"],["Click a bar to see the rows behind it","SG",11,null,null,"rows.sql?m=leads_invoiced_finance&period=2026-09&dim=canton&value=SG"],["Click a bar to see the rows behind it","TI",9,null,null,"rows.sql?m=leads_invoiced_finance&period=2026-09&dim=canton&value=TI"],["Click a bar to see the rows behind it","GE",6,null,null,"rows.sql?m=leads_invoiced_finance&period=2026-09&dim=canton&value=GE"]]
}
The SQL behind this page
select canton, count(*)
from leads
where invoiced_at >= '2026-09-01' and invoiced_at < '2026-10-01' -- Europe/Zurich
group by canton
order by 2 desc;