Rollbar RQL query to pull number of exceptions that have occurred in the last 60 days

rollbar.rql

SELECT body.trace.exception.class, count(*), sum(item.total_occurrences), min(timestamp), max(timestamp), level, environment, item.status
FROM item_occurrence
WHERE timestamp > unix_timestamp() - 60 * 60 * 24 * 77
  AND item.status = 1
  AND language = 'ruby'
  AND item.level >= 40
  AND environment = 'production'
GROUP BY body.trace.exception.class
LIMIT 500

why 60 * 60 * 24 * 77 not 60 * 60 * 24 * 60?

Probably no good reason 😓

I think i wanted an extended time window to make sure I captured all the events.