Filter on MAX date
My customer would like a report that lists all Organizations (distinct) that have not had an Incident created in the last 6 months.
In all other reporting tools, first, I would get the max(created_date) and then filter on that date.
Service Cloud filters don't seem to allow that.
Can someone point me in the right direction?