TAC Leads

view name = 'tac_leads'

[NEW] Query

 SELECT date_trunc('day'::text, leads_date)::date AS date,
    to_char(date_trunc('month'::text, leads_date)::date::timestamp with time zone, 'YYYY Mon'::text) AS month,
    (to_char(date_trunc('week'::text, leads_date)::date::timestamp with time zone, 'DD Mon'::text) || ' - '::text) || to_char(date_trunc('week'::text, leads_date)::date + '6 days'::interval, 'DD Mon'::text) AS week,
    branch,
    contact_owner,
    assigned_pic,
    source,
    sremarks,
    medium,
    mremarks,
    count(leads_date) AS leads
   FROM combined
  WHERE hide IS NULL OR hide = false
  GROUP BY (date_trunc('week'::text, leads_date)::date), (date_trunc('day'::text, leads_date)::date), (to_char(date_trunc('month'::text, leads_date)::date::timestamp with time zone, 'YYYY Mon'::text)), ((to_char(date_trunc('week'::text, leads_date)::date::timestamp with time zone, 'DD Mon'::text) || ' - '::text) || to_char(date_trunc('week'::text, leads_date)::date + '6 days'::interval, 'DD Mon'::text)), branch, contact_owner, assigned_pic, source, sremarks, medium, mremarks
  ORDER BY (date_trunc('day'::text, leads_date)::date);