I have a table in Coda with almost 500 rows. I just want to show the top 100 rows with the highest count. The column ‘Count’ is already sorted to decreasing value. How will I do that in Coda ? What filter formula should I use ? Thanks! [image]

There may be an easier way that I’m not thinking of, but one way would be to use the Rank function in its own column to assign a rank to each row, then just filter on that rank column (i.e. only show rows with Rank <=100).

Dear @Alyssa_Gono , Please find in the below link a detailed explanation: [image] Using Slice to limit the rows in a view (return Top n rows) Tips and Hacks Here’s an example with a walkthrough of the key steps: Credits: @shishir

Thank you for the idea. It helped me.

thisRow.In(thisTable.Sort(false, thisTable.Count).Slice(1,100)) This helped me. thanks

Display only the Top 100 rows

Ask the Community

Jean_Pierre_Traets December 13, 2022, 4:12pm 3

Dear @Alyssa_Gono,

Please find in the below link a detailed explanation:

Credits: @shishir

Topic		Replies	Views
Fisrt 5 Rows of table Ask the Community	4	833	October 23, 2021
Using Slice to limit the rows in a view (return Top n rows) Tips and Hacks	32	9870	August 6, 2022
Best way to limit table length? Ask the Community	1	766	September 9, 2022
How to sort (in the formula) when the Top 3 rows are filtered out Ask the Community	1	708	May 7, 2021
Show up to X number of rows? Ask the Community	1	1729	April 27, 2021

Display only the Top 100 rows

Related topics