Revenue (Finance)

The amount billed to brokers in CHF, counted on the invoice day. Owner: Finance.

name: revenue_finance
label: Revenue
noun: invoiced leads
description: The amount billed to brokers in CHF, counted on the invoice day.
measure: revenue_chf
time_basis: invoiced_at
owner: finance
certified: true

select coalesce(sum(invoice_amount_chf), 0) as value
from leads
where invoiced_at >= timestamp '2026-09-01 00:00:00' at time zone 'Europe/Zurich'
  and invoiced_at < timestamp '2026-10-01 00:00:00' at time zone 'Europe/Zurich'

select to_char(invoiced_at at time zone 'Europe/Zurich', 'YYYY-MM') as period,
       coalesce(sum(invoice_amount_chf), 0) as value
from leads
where invoiced_at >= timestamp '2026-04-01 00:00:00' at time zone 'Europe/Zurich'
  and invoiced_at < timestamp '2026-11-01 00:00:00' at time zone 'Europe/Zurich'
group by 1
order by 1

select canton as label,
       coalesce(sum(invoice_amount_chf), 0) as value
from leads
where invoiced_at >= timestamp '2026-09-01 00:00:00' at time zone 'Europe/Zurich'
  and invoiced_at < timestamp '2026-10-01 00:00:00' at time zone 'Europe/Zurich'
group by 1
order by 2 desc, 1
limit 50

The app runs these queries with parameters; here the values are written in, so they can be read or pasted into psql.