📍 Top reported locations

Custom SQL query returning 10,293 rows (hide)

select offence_location as Location, council_area as [Council area], count(*) as [Total reports], sum(case when disposal in ('Fixed Penalty', 'Court') then 1 else 0 end) as [Fines/court], sum(case when disposal = 'Education' then 1 else 0 end) as Education, sum(case when disposal = 'Warning Letter' then 1 else 0 end) as [Warning letters], sum(case when disposal = 'NFA' then 1 else 0 end) as NFA, round(100.0 * sum(case when disposal != 'NFA' then 1 else 0 end) / count(*), 0) as [Action rate %] from reports where offence_location is not null group by offence_location, council_area order by [Total reports] desc

Edit SQL