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.
Hi @hem_patel,
Have you tested the denserank function? What did you test out for your calculated field and how did the outcome differ from what you’re trying to achieve?
When it’s getting filtered down, will it always be based on the same field or are you trying to show the first 10,000 results based on multiple variables?
Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions regarding your initial post or were you able to find a work around in the interim?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.