Problem with a simple TOP5

Anonymous — Wed, 14 Oct 2020 15:07:14 GMT

I everyone,

I am trying to make a simple top 5 on a table.

So I created a filter "First N" filtering the first 5 rows by Amount Desc.

The table is something like this:
DATE | STORE | N° Gift card | Amount

But the filter won't work, I keep getting too much lines, (I clicked on "apply filter"), I tried to do this on visuals in case it was the "table visual" that wasn't compatible with the TOP N filter but it doesn't work either.

Do you have any ideas why a filter that simple wouldn't work ?

Thanks a lot guys ! Do not hesitate to contact me if you need more info.

Re: Problem with a simple TOP5

lbendlin — Thu, 15 Oct 2020 20:55:59 GMT

Do you have a lot of gift cards with the same amount? You can add a small random value to the amount in order to break the ties.

topic Re: Problem with a simple TOP5 in Developer

Problem with a simple TOP5

Re: Problem with a simple TOP5