If you have a large data set and you'd like to present its summary with an Infogram chart, you can do so with the aggregate data option. It allows you to aggregate entries with the same values, and group them by categories.
Enable data aggregation
- Select the chart you wish to use, head over to the settings panel on the right, expand the Chart properties tab, and toggle on Aggregate data.
- You can also access this option in the Edit data tab under the gear icon.
Populate the datasheet
After enabling the Aggregate data option, you'll notice that your chart has a datasheet with three columns. Add data as you would in a regular chart, but make sure that the formatting matches the one displayed below.
- Use the first column for reference, as the information entered here will not be visible in the chart.
- Enter values in the second column – the chart will display the sum of identical values. E.g., if there are four 'apple' entries here, the chart will show that the amount of 'apple' equals 4.
- You can group values by categories in the third column. They will appear in the form of tabs in one-dimensional charts (e.g., columns and pie charts) or data points in two-dimensional charts (e.g., line charts).
Browse through the articles available in the Charts section of our Support page to see how Infogram charts can be customized.
Example of a use case
Aggregate data are useful in various cases. E.g., you might want to display voter turnout in elections, unemployment rates and various demographic data, as well as survey results and much more.
- Let's say you've conducted an online poll and have gathered answers to some questions. You can use the first column of the chart for indicating the respondents, the second column for their answers, and group the questions into categories in the third column.
- Your audience can click through the tabs and see all of the answers to your questionnaire.