In Rows you can aggregate equal values in charts which can help simplify your data visualization by grouping identical data points or categories. This process makes your charts easier to read and enables you to highlight trends or patterns effectively.
To aggregate equal values, follow these steps:
- Select the data that you want to visualise and then navigate to Insert > Chart
- Select the appropriate value for the Main axis
- Toggle the option to Aggregate equal values. You can choose from one of the following aggregators:
- AVERAGE
- COUNT
- MAX
- MEDIAN
- MIN
- SUM