Result set limit for authoring mode

When you create a report, by default Visualizer limits the number of rows in a query result to 100. This number is indicated in the Visualizer toolbar.

While creating a report, if the total number of data points in the report is 100 or more, you see a message "Top 100 data points being visualized. Please change the limit to visualize more data points."

Note: The default top 100 results are the first rows returned by the query. This is not exactly the same as Top N which requires that a sort be applied. See Visualizing Top N / Bottom N results.
Caution: Before saving a report, make sure the Top N provides what you want for your business users. For example, "All" may be too many rows and may affect performance. Alternatively, 100 rows may not be enough.
  1. Click the Top N Results icon.
  2. Click the last option button to specify a custom number of records.
  3. Specify the new number.
  4. Click Apply.