A message "Only the first 500 items are shown" is displayed on the chart

Article Number:040246

If the total number of Level 1, 2, and 3 items specified for "Group by" exceeds 500, a message "Only the first 500 items are shown" may be displayed at the upper right of the aggregate result screen.
If this message is displayed, the first 500 items are displayed on the aggregate result based on the "Sort by" setting for the chart.

The message appears when the chart type is one of the following.

  • Bar chart
  • Column chart
  • Line chart
  • Spline chart
  • Area chart
  • Spline area chart
  • Pie chart

Solutions for this error are as follows:

  • Configure filter conditions for the chart so that the total number of Level 1, 2, and 3 items does not exceed 500.
    Reference: Adding Charts from the App Settings Page

  • Use "Pivot Table."
    The number of Level 1 and 2 items that can be displayed in a pivot table is 50 and 1,000 respectively.

  • Use "Table."
    You can display the top 10,001 items of the aggregate result.

  • Export the aggregate result to a file.
    You can display the top 10,001 items of the aggregate result.
    Reference: Exporting an Aggregate Result to a File