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

Article Number:040246

If you create a chart with more than 500 groups of data aggregated using the Group by settings, the message "Only the first 500 items are shown" may be displayed at the upper right of the screen with your aggregated data.
In such a case, only the first 500 groups of data sorted by the Sort by settings for your chart will be displayed.

This error message is displayed on the following chart types.

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

Solutions for this error are as follows:

  • Configure your chart's filter settings so that no more than 500 groups of data are aggregated using the Group by settings.
    Reference: Creating charts on the "App settings" screen

  • Use a pivot table and set the filter settings so that both of the following conditions are met.

    • No more than 10,001 groups of data are aggregated using the Group by settings.
    • Data aggregated using the Group by settings fits in 1,000 rows and 50 columns (excluding rows and columns for titles and total values).
  • Use a table and configure its settings so that no more that 10,001 groups of data are aggregated using the Group by settings.

  • Export the aggregated data to a file.
    In the file you can check the first 10,001 groups sorted by the Sort by settings.
    Reference: Exporting aggregated data to a file