Report last ticket solved by an organization

I'm trying to create a report that will show only the most recent solved ticket by organization. So basically  report that lists all of our organizations with the one ticket that was most recently solved and the date.

Zendesk support told me to “create a metric and from there calculate the most recently solved ticket, which would likely utilize the existing attribute 'Ticket Solved - Date' (or something similar like timestamp).” What they didn't help me with is how or what to create the metric based on. I would be incredibly grateful if anyone has any suggestions. Thank you in advance!