Below is a select statement that select incidents by month. I need a
function or a method to select differents views that will show the Month
columns is a different order. Say Apr - Mar for a fiscal year.
I need to do something like an if/then/else statement that selects the
correct view to use by a variable check.
Any ideas what I can use or do ?
select case public.incident.gender_code_id
WHEN 31 THEN 'Male'
WHEN 32 THEN 'Female'
ELSE 'Non-Person'
END,
count (case extract ( month from public.incident.incident_date
)WHEN 01 then 1 Else NULL END) as Jan,
count (case extract ( month from public.incident.incident_date
)WHEN 02 then 1 Else NULL END) as Feb,
count (case extract ( month from public.incident.incident_date
)WHEN 03 then 1 Else NULL END) as Mar,
count (case extract ( month from public.incident.incident_date
)WHEN 04 then 1 Else NULL END) as Apr,
count (case extract ( month from public.incident.incident_date
)WHEN 05 then 1 Else NULL END) as May,
count (case extract ( month from public.incident.incident_date
)WHEN 06 then 1 Else NULL END) as Jun,
count (case extract ( month from public.incident.incident_date
)WHEN 07 then 1 Else NULL END) as Jul,
count (case extract ( month from public.incident.incident_date
)WHEN 08 then 1 Else NULL END) as Aug,
count (case extract ( month from public.incident.incident_date
)WHEN 09 then 1 Else NULL END) as Sep,
count (case extract ( month from public.incident.incident_date
)WHEN 10 then 1 Else NULL END) as Oct,
count (case extract ( month from public.incident.incident_date
)WHEN 11 then 1 Else NULL END) as Nov,
count (case extract ( month from public.incident.incident_date
)WHEN 12 then 1 Else NULL END) as Dec,
count (extract ( month from public.incident.incident_date )) as
Total
from public.incident
GROUP BY public.incident.gender_code_id
