Incident last updated by and last status change by
Happy new year!
I have a report which lists incidents. I want to show who last updated it and who did the last status change. They can be the same person at the same time or different times.
The formula I have the last updated by is as follows (where the report is currently filtered on Created and Edited):
substr(max(concat(date_format(transactions.created, 'YYYYMMDDHH24MISS'), NVL(transactions.acct_id, 'System'))),15)