Suppose you have a table with 10,000 records, and you want to add a filter that allows you to specify a percentage (e.g., 10%) and filter the table to display only 10 percent of the data. what is a creative work around
You could make a percentage using rank where it would rank the columns based on whatever sort you want and then divide by the count of rows.
rank([{arrival_timestamp} DESC],[])/count({arrival_timestamp})
Then filter on this percentage ^
1 Like
Hi @Sam_Shamsan, We hope above solution worked for you. Let us know if this is resolved. And if it is, please help the community by marking @Max’s answer as a “Solution.
Regards,
Kathik
1 Like