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

Question & Answer
, ,
1

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

2

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
3

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