...
SELECT
--date(submitted),
case
when lower(request) like '%entity%' or request like ' %Entity%' then 'Edit'
when substrlower(request,1,4) like 'data' or request like '%ExecuteData%' %executedata%' then 'Data'
when lower(request) like '%edit%' or request like '%Edit%' then 'Edit'
when lower(request) like '%dms%' or request like '%Dms%' then 'Dokument'
when lower(request) like '%select%' or request like '%Select%' then 'Urval'
when lower(request) like '%index%' or request like ' %Index%' then 'DokumentSnabbsök'
when lower(request) like '%search%' or request like ' %Search%' then 'DokumentSökningar'
when substrlower(request,1,5) like 'admin%admin%' then 'Admin'
when lower(request) like '%report%' or request like '%Report%' then 'Rapporter'
when lower(request) like '%list%' or request like ' %List%' then 'Listor'
when lower(request) like '%map%' or request like ' %Map%' then 'Kartor'
when lower(request) like '%export%' or request like '%Export%' then 'Export'
else 'Övrigt'
end as kategori,
count(request), sum((duration+500)/1000) as seconds, sum((duration+500)/1000) * interval '1 second' as hms
FROM weave.wv_statistics
--where request = 'com.cohga.ExecuteReport'date(submitted) = date(now())
group by 1
order by 3 desc;
