How do I limit report to last 10 non sequential dates?

Nick Eddy shared this question 17 months ago
Answered

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?

Comments (3)

photo
1

Hi Nick,


One idea here is to use a time difference calculation to get the difference between now and the event date as an integer (seconds). You can then run the Top N on top of that value. Let me know if this makes sense!

Nathan

photo
1

Hi Nathan,

Thanks, worked it out similar to suggestion - created calculated field converting event date to unix timestamp which I then applied rank function to.

Thanks.

photo
1

Glad to hear its worked out!