Another common data processing scenario involves limiting the rows/columns displayed on the slide. Even if the input Query provides all responses, this can be done within the dynamic row/column definition already on the Compose side.
One example would be taking just the first/last X rows from the input table. This can be done using the functions Head and Tail. When combined with the Sort function, these can be used, for example, to retrieve the Top X or Bottom X responses from the Query.
In some cases, it may also be useful to skip X's first rows from the input, which is something that the Skip function allows us to achieve. Let’s say we want to prepare a slide that shows one table with the top 10 entries and a separate table with responses from positions 11-20. For the first one, the example above with Sort + Head will be sufficient. However, for the second one, we can extend the dynamic row definition to Skip the first 10 rows - this way, our top 10 calculation will ignore the first 10 rows and return items from positions starting with 11.
