1

Zendesk – how many tickets are created by month?

Question

How many Zendesk tickets are created by month?

Sources

Zendesk (full schema here

Query

select date_trunc('month', t.created_at) as month,
       count(t.id)
  from zendesk.tickets t
  group by month
  order by month desc