Report notification that contains data from a selected number of rows in the notification text

[Laurens_Swart]

I would like to send a daily report with the top 5 rows from a table (they can be selected as e.g. the 5 rows with the most recent date in the DATE column). From these rows, I need the NAME variable, to use in a daily notification that gets send out at 4PM stating the top 5 people (the most recent 5 people).
Can this be done?

It would have to a report “ForEntireTable” I assume, since I want to pull data from multiple rows and I only want a single notification to all users.
What would I have to type in the Notification field to get the NAME field from the 5 rows from my table that have the most recent DATE?

Thanks for your help!

Edit: Never mind, I figured it out after some researching in the help docs.

Notification text:
Top 5 people today: << TOP(ORDERBY(FILTER(“People”, TRUE), [Date]), 5) >>

(the [Name] field is my table’s key, so it works).