How do I limit report to last 10 non sequential dates?
I am trying to build a report showing last 10 events based on event date.
My problem is that the Top N advanced functions used in tutorials & examples are not available for datetime fields, so how do I rank using the date?
I cannot use the ID field as they are not in sequence with the event date field.
Other option is to sort by event date, then set the report row limit to 10, but then Yellowfin displays the truncated data set message which I don't want.
Any ideas to get around this?