Ranked largest first; each bar is a share of the largest. Largest: budget £192k.
Show the figures as a table
lost_reason
ARR lost
budget
£192,150
in_house_build
£166,000
acquired_competitor
£123,200
customer_insolvent
£44,000
About this view
Asked: Why did we lose the customers we lost, and who looks like them now?
Saved: Thu 15 Oct 2026, 10:21 UTC
Figures as at: 2026-10-09
Table q: 4 rows from select lost_reason, sum(arr_lost) as arr_lost from (with lost as (select org_id, org_name, month_end, arr_bf as arr_lost from chat.arr_moves where type = 'lost'), d as (select org_id, lost_reason, close_date, row_number() over (partition by org_id order by close_date desc) as rn from chat.deals where stage = 'closed_lost' and deal_type = 'renewal') select l.org_id, l.org_name, l.month_end, l.arr_lost, coalesce(d.lost_reason, 'not recorded') as lost_reason from lost l left join d on d.org_id = l.org_id and d.rn = 1) group by lost_reason order by lost_reason LIMIT 1000
This view was drawn for a chat answer and is read-only. Click a mark to filter the others, use the slicers, open the rows behind any chart or download them as CSV.
BB-Demo is a fictional company; every organisation and person here is invented. B-Brain is the tool. Built by site/build_site.py from the site tree, data as of Fri 9 Oct 2026. Help & Support