Overall Context: I want a user to be able to access all the data in a dataset but only 1,000 records at a time in a table visual.
E.G. The user should be able to view 1,000 records from a 10,000 record dataset. If they sort by a date for example they can sort to see the most recent 1,000 records or the oldest 1,000. If they then sort by Contract Value, they can see the 1,000 highest value or the 1,000 lowest value, in theory this could be 4,000 unique rows they have viewed (although in reality there would be overlaps with value and dates). Key thing here is the data visible can be from the full 10,000 records and it isn’t a pre-filtered limit based on sorting by a few fields.
My solution for this was to create a dynamic row number that regardless of how a table is sorted will always be a sequential figure starting from 1. It will essentially be like the row number in a spreadsheet, however it would be recalculating to re-order back in 1,2,3,4 after every sort. if I create that field then I can I hope use a Top N Filter on this calculated field. However I can’t seem to get it to work, have looked at the following article:
However that doesn’t seem to work. Also tried, hoping the post_agg_filter was the key but I couldn’t get it to work and also not sure it will achieve what I wanted.