Is there a way to limit the number of rows initially displayed in a chart object? Currently, I have a straight table that loads thousands and thousands of records and is taking up time and memory. Is it possible to display the first 100 records and have a way for users to navigate to the next 100 and so forth?
I realize that the dimension limit can be set to restrict the number of values displayed, but this does not allow users to ever see the complete record set. Often times, users want to be able to export all records to Excel for further manipulation and not just the first 100.
Any help would be greatly appreciated. Thanks in advance!
You can predefine selection of the first 100 rows by default and then the user can change it.
If export to Excel is the only reason you can use minimized/hidden object that should not consume much memory until is used.
You can use dimension limits, just set the value for the first # of rows to be a variable like vLimit. Then use either an input box or maybe a textbox to toggle between 100 and all records.
Hope this helps!
You can assign a variable to display n rows of data. You can default it to 100. Create an input box and whenever the user changes the value to say 300 that many rows will be displayed.
Another technique which is commonly used is not to show anything at all until certain specific selections are made (Calculation Condition). It has a huge impact on performance.
Because looking at the entire data may not be productive, so make them narrow down the selections based on business inputs on how they would use the chart for analysis.
Hope it helps.
It is possible, but somewhat limited.
See attached. There is table "Data", and next, in the script, I created field TableSortOrder. Since it is in the script, it is predefined and can be changed in the script only. Do not allow interactive sort either.
Page Size can be changed on the front end. Added buttons to scroll between pages.
Hi Michael. From what I can see your solution will not work properly if the user makes selections, since the row numbers is in the data, which I think is what almost everyone looks for.
Is it possible to always show a certain amount of rows, independently of the user's selections?
How can we achaive the same results with Multiple Dimension. With Multiple Dimension ""DIMENSION LIMIT "" does not work.
Please advse if we can handle the row limit on straight table chart with MULTIPLE DIMENSION SAY MORE THAN 5 DIMSNION.