Limit Number of Rows in View

badm
Participant IV

I have created a deck view of the data that I need. How can I only show the first 100 rows?

0 4 328
4 REPLIES 4

Create a slice with condition such as [_RowNumber]<101

@Bellave_Jayaram
Sir, I just wanna require a solution for my question. I need to show the first 100 rows, and meanwhile meet the need of โ€œscoreโ€ column (data is digital) data <=30 and >=10. How can i achieve this? Please help me, thanks in advance.

Iโ€™ve never done exactly what you are trying to do and I havenโ€™t had a change to test this but I wonder if the following wouldnโ€™t work as your slice condition:

IN([Name of your key column],TOP(FILTER(โ€œName of your tableโ€,AND([score] <=30,[score] >=10)),100))

If Iโ€™m wrong Iโ€™ll be interested to see what the correct solution is.

This is the same thing but it should be a litle easier to understand:

IN([Name of your key column],
    TOP(
        FILTER("Name of your table",AND([score] <=30,[score] >=10)
    ),100)
 )

It you know what FILTER(), TOP(), and IN() do, then you should be able to understand what this expression is supposed to do.

Top Labels in this Space