Using Slice to limit the rows in a view (return Top n rows)

[Alexandru_Dan]

Hi, Joost,

Thank for your help. I am a noob here so I hope I’ve managed to do it properly. If not, I’ll do it again

[joost_mineur]

Hello @Alexandru_Dan ,

You did the right thing, but upon adding a filter:

you have to check either one, checked or unchecked:

sometimes it is a bit easier to user formulas instead of just clicking.

Greetings, Joost

[Alexandru_Dan]

Well, I’ve tested it with checked/unchecked just to be sure and it did not work either. As you can see there are just three rows displayed. My issue was with a lookup and just tested it with the checkup boxes, maybe the lookup wasn’t meant for that (although it should work). Pleas see in the Prioritzare vew that a lot of CheckboxTest are checked.

[joost_mineur]

Hello @Alexandru_Dan

It works as expected, but I think you want something different from what you are telling the filter.
Change the AND to OR and see if that is what you want to see?

Greetings,
Joost

[joost_mineur]

I changed if for you, now you see a lot more items. With AND you see the cross sections of items that fulfil both filters, with OR you see items that fit one or the other (or both).

[Alexandru_Dan]

@joost_mineur - Hmmm, maybe I did not understood completely the function. I needed the last (or first) rows from the table. This is happening if just the Slice filter is activated. If I add some other filter, it doesn’t behave correct, or at least this what I am seeing.

thisRow.In(thisTable.Sort(false, thisTable.crITic).Slice(1, 5)) - i have the table sorted descending [sort(false.] and then Slice 5 position from the first one. All good. If I add another filter before or after this Slicing, it doesn’t work and it doesn’t make sense. I should have 5 rows despite other filters. There are more than 5 rows with the checkbox activated that can be sorted by “critic”. There is something that I am missing in this…

[joost_mineur]

Hey @Alexandru_Dan ,

I am pretty sure it is not a bug, but a formula thing. I am using filters every day - and some pretty complicated ones (although upon review they can usually be less complicated for the same results and better performance).

So, I will take another look, but it would help if you show me (just type a little list) what you are trying to accomplish, because the only thing you say is that the 2nd filter doesn’t work, at least it doesn’t give you what you expect, but I don’t have a clue what you are trying to accomplish.

If you want the top 5 of the items that are checked, that’s definitely possible, but in that case we need to change the filter a little bit.

Greetings, Joost

[Alexandru_Dan]

Thank you for your patience, @joost_mineur

I want to see just the last/first 5 not-daily activities (zilnic) from a view ordered by criticality. I hope I was clear enough. If not, I am here

Best!

[joost_mineur]

@Alexandru_Dan ,

Done!

Greetings, Joost

[Alexandru_Manescu]

Thanks @shishir
(3 years later, still a valuable resource )

[balupton]

I have a table with over 2000 rows that is refusing to be charted - how can I performantly filter it to say the most recent 2000 rows? thisRow.in(thisTable.slice(0, 1999)) slows it to a crawl

[Christiaan_Huizer]

what about a filter type to get a filtered view of your table?

[joost_mineur]

I added a rank column to my table and in the chart I show only the highest ranked 2000 records. That performs reasonably well.
The max() part of the formula is to make sure you see something if you have less than 2000 rows in your table.