SELECT month,
SUM(case when услуга = 'Регистрация пользователя ЕСИА' then заявления end ) as count1,
SUM(case when услуга = 'Восстановление пароля пользователя ЕСИА' then заявления end ) as count2,
SUM(case when услуга = 'Получение статуса заявки на регистрацию ЕСИА' then заявления end ) as count3,
SUM(case when услуга = 'Подтверждение кодов регистрации ЕСИА' then заявления end ) as count4
FROM(
SELECT
  AVG(EXTRACT(EPOCH FROM o.order_date AT TIME ZONE 'UTC')) / 10000000000 AS d,
  to_char(o.order_date, 'dd.mm.yyyy')                                    AS дата,
-- так например
  ,extract('month' FROM o.order_date)::int             AS month
--
  COUNT(*)                                                                     AS заявления,
  substring(m.title FROM 0 FOR 48)                                       AS филиал,
  substring(u.title FROM 0 FOR 48)                                       AS оператор,
  o.service_title                               AS услуга
--,  o.order_datemonth as month -- yf[eq
FROM smartcenterorder o, smartcentermfc m, smartcenteruser u
WHERE o.order_date BETWEEN $P{from} AND $P{to}
GROUP BY дата, филиал, оператор, услуга,month
) as fo
GROUP BY month
ORDER BY month