Top 3 by Date

[ashleyinman]

I have numbers that have multiple dates and a note entered for each date. I would like the take the most recent 3 dates but not sure how to do this with the Sample tool.

[neilgallen · Accepted solution]

@ashleyinman I would recommend sorting your data by whatever field you are using for the grouping, and then by the date. Then use a sample tool, choosing "First N Rows" and N=3.

Then ensure the check box for "Group by Column (optional)" is selected for whatever field you are using for groupings.