Interesting question: filter 10% or x% of my data

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.


1 Like