Choose which rows to show in table, first 24,99 then 25,000 - 49,999 etc.

[PaulK]

Hi 

Is it possible to choose which rows are visible in a straight table, so you can choose the first 24,999 rows then 25,000-49,999 then 50,000-74,999 etc.? So on the sheet you have the option to choose which group of 24999 rows are visible at any one time

Thanks

Paul

[draghici1109]

I am not sure, but have you considered to use RowNo() with an WHERE Clause?

[PaulK]

Thank you for your reply.

I've added the RowNo() to the table which does give a number to each row. On the sheet how would I then have an option for the user to select which 24999 rows are visible at any one time? Can a filter be added with the options?

Thanks
Paul

[marcus_sommer]

IMO it's not a good idea to show so much rows within a chart. Probably the object is aimed for an Excel export and is too slow and/or runs into RAM restrictions or timeouts. Better would be to create the wanted output data already within the script and to store them as csv.

Beside this you may apply the mentioned rowno-cluster within the script with something like:

mod(rowno(), 25000) as RownoClusterFlag

Within the UI is such a direct clustering not possible. You may do a count on the available dimension-values of the chart within a list-box, like:

ceil(aggr(count(Field1&Field2, Field1, Field2, Field3, ...)) / 25000)

but by having already performance issues it's rather not expedient.

Apart from this I did already exports with more as 100k of rows - if the chart isn't too heavy (by the calculation and the number of columns). Therefore optimizing the data-model and/or the chart may also a solution - and not for this use-case else in general.