The message "Only the first 500 items are shown" is displayed on a chart
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:
- Set chart filters to ensure that the number of groups in the aggregated data does not exceed 500 when using Group by.
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.
- If the Group by section is configured, the total number of groups in an aggregated data is 10,001 or less.
- If the Group by section is configured, the chart of the aggregated data fits in 1,000 rows and 50 columns (excluding rows and columns for titles and total values).
- Use a table to ensure that the number of groups in the aggregated data does not exceed 10,001 when using Group by.
- 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