When you create custom reports with the Reports Builder, tickets that have been  Ticket archiving will not show up if you query only for resolved tickets.

Archived tickets have a tickets.status value of ‘archived’.

To ensure you match resolved OR archived tickets, you should check for:

WHERE tickets.status IN ('resolved', 'archived')
 copy

There is also a tickets.date_archived field which indicates when the ticket was last archived.

Note that the built-in reports for resolved tickets already include archived tickets.