Top N per group view?

Posted by Rollbase User on 12-Dec-2012 00:46

Is there a way to create a view that shows the top N records per group? ie, if I have responses to questions, I'd like to show the latest 3 responses for each question.

All Replies

Posted by Admin on 12-Dec-2012 18:16

I would approach this by:

1. Creating a report on the Response object Grouped by related Question, and

2. Setting a filter on the Response object's Updated At field

This would almost get you there except you wouldn't be limiting it to 3 or N per question.



In order to limit the # rows per question to a specific number you may need to build this using a custom JavaScript based report using the query API and JS arrays to then render the data.



Hopefully this is somewhat helpful,

Matt

This thread is closed