topic Re: Select the Top N values of a chart in Insight Advisor

Select the Top N values of a chart

jonathan2433 — Tue, 15 Nov 2022 15:37:31 GMT

Hi,

I have a chart with 10000 rows, and i want to SELECT the 500 first values/rows of them.

How can i do that ?

Thanks 🙂

Re: Select the Top N values of a chart

Mark_Little — Tue, 15 Nov 2022 15:47:48 GMT

HI @jonathan2433

With the Chart options, under the dimension you have the Option for limitation and you can choose the top x and set it to what you want i.e. 500

Re: Select the Top N values of a chart

jonathan2433 — Tue, 15 Nov 2022 15:49:53 GMT

Hi @Mark_Little , that's not what i need, this solution is to DISPLAY the First 500, what i need is to SELECT the values to add them on my filters 🙂

Re: Select the Top N values of a chart

Mark_Little — Wed, 16 Nov 2022 07:35:41 GMT

The devil is in the detail, not sure how you would do this as a default, but you can add a condition to on the table to only calculate when there is 500 or less line and direct the use make some selections.