BMC - top N ranks on dates BMC smart reporting
Is there a way to do a top N ranks on date fields / columns using Smart Reporting?
I have a requirement where for each unique ID (identified from a different form) there are multiple rows / records in the system which has the submit date of the record. From these rows, for EACH unique ID I want to only identify the submit date of the second record.
I know there is the functionality of Top N Ranks in Smart Reporting, but have not found a way to use this with dates.