Limit

[Cyril3131]

Hello everyone,

I have a simple table. I just want to display only 3 rows (in order by date).

I didn't find a display limit... Someone can help me ?

[joaopaulo_delco · Accepted solution]

Hi @Cyril3131 !

      To limit lines of a dimension, you have to put a measure in you table.

You can substitute the dimension "Planned Start" to a measure Max(Planned Start).  Change the format field to Date.

After put the measure, you be able to limit the lines in the dimension "Name" proprierties like image below:

If you don't wanna use the Max() expression, you can use Only().

[Cyril3131]

Hi  @joaopaulo_delco,

Thanks for the reply, it works, but it's strange, I don't know why, but when I sort on the date (ascending), I don't have the first dates of the top 5, but 5 dates in 2022.

Do you know what happened?

[joaopaulo_delco · Accepted solution]

@Cyril , you have to define this on limit configuration. 

You choose "Superior" or "Inferior" like below:

It's not possible to change the sort on column and apply the limits.

[Cyril3131]

Thanks @joaopaulo_delco , I understand how it works now 🙂 

[joaopaulo_delco]

@Cyril3131Please mark the post as solved if the tip has solved your problem.