{
"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)",293,null,null,"rows.sql?m=appointments_operations&period=2026-09&dim=product&value=Basic%20health%20%28KVG%29"],["Click a bar to see the rows behind it","Supplementary (VVG)",91,null,null,"rows.sql?m=appointments_operations&period=2026-09&dim=product&value=Supplementary%20%28VVG%29"],["Click a bar to see the rows behind it","Life",39,null,null,"rows.sql?m=appointments_operations&period=2026-09&dim=product&value=Life"],["Click a bar to see the rows behind it","Car",36,null,null,"rows.sql?m=appointments_operations&period=2026-09&dim=product&value=Car"]]
}
The SQL behind this page
select product, count(*)
from leads
where appointment_status in ('scheduled', 'held')
and appointment_at >= '2026-09-01' and appointment_at < '2026-10-01' -- Europe/Zurich
group by product
order by 2 desc;