group by month and year

sql

select format(created_at, 'MM.yyyy') as created_at
, sum(tolerance) as t_sum
, sum(measured_value) as t_measure
from ncr_tickets as n
group by format(created_at, 'MM.yyyy')


Ncr::NcrTicket
.select("sum(tolerance) as tolerance, sum(measured_value) as measured_value, format(created_at, 'MM.yyyy') as created_at")
.group("format(created_at, 'MM.yyyy')")