Result set limit for authoring mode

When you are creating 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 are 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 Results .
Caution: 
Before saving a report, check to 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 enter a custom number of records.
  3. Specify the new number.
  4. Click Apply.
Related topics