Can I group incidents.created_by by the groups the accounts belong to?
I'd like instead to group by groups based on which accounts created an incident (incidents.created_by) rather than the currently assigned account.
Unfortunately, I don't seem to be able to do this. Any fancy table joining I can do?
Thanks in advance.