topic Re: Limit in App Development

Limit

Cyril3131 — Fri, 06 Aug 2021 10:43:43 GMT

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 ?

Re: Limit

joaopaulo_delco — Fri, 06 Aug 2021 18:37:22 GMT

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().

Re: Limit

Cyril3131 — Tue, 10 Aug 2021 10:12:01 GMT

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?

Re: Limit

joaopaulo_delco — Tue, 10 Aug 2021 12:30:09 GMT

@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.

Re: Limit

Cyril3131 — Thu, 12 Aug 2021 10:05:39 GMT

Thanks @joaopaulo_delco , I understand how it works now 🙂

Re: Limit

joaopaulo_delco — Thu, 12 Aug 2021 12:01:21 GMT

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