Help with a formula (filter bottom 3 answers)

1

Hello dear community! I am quite new as a Coda user and I would need some help displaying the correct information in a table. Here’s the context:

I have a first table (tab1) that shows a list of questions (questions), a rating out of 10 stars for 5 participants (one participant per column), and a total number of votes (total) in another column.

I would like to display in a second table (tab2), below the main table, the “questions” that received the fewest votes (top 3 fewest votes) and the total number of votes received by each “question” (for each row), again in a top 3 format.

Could someone explain how to write such a formula?

2

Hi Jonathan,

Welcome to Coda and the community.

Here is a generic example of how to get the "last N numbers in a table. I hope that gets you going in the right direction:

Regards
Piet

3

Hello Piet_Strydom,
Thank you for your help. I must admit that, as a beginner with Coda, I am having a lot of difficulty understanding your example. Is there a way to be more specific in relation to my needs?
I really appreciate your time. Thank you so much.
Here’s an image of what I’m trying to do. Show the 3 questions with less vote in the bottom table.

image
image1291×707 63.8 KB