Duplicated values and rows
This article helps you understand reasons behind duplicates you might encounter in your Insights visualizations.
Scenario
You've created a visualization and see duplicated rows like in the pivot table below.
Duplicates can be visible when you create a chart or even appear later. In both scenarios; the root cause of the duplicates are always the Multi-select values in the table fields.
Multi-select fields are table fields with check-box options. For example; Products/Services; Categories; Account Manager and other table User-Defined fields created in your company that are Multi-Select Fields that are only available internally.
Reasons
- If somebody chose or changed a record to multiple Products or other multiple Values in table Account UDF; like in the example above; this record can have duplicates depending on the chart.
- A new filter was added and this is a table field with Multi-select values.
How to Avoid
- Remove Multi-select values from any table fields related to the chart you built.
- If (1) is impossible; apply Multi-pass formula to prevent multi-selects:
Example:
SUM (Identification; Average Corporate Revenue)
Read: group by Account Identification and if there are multiple records; count revenue only once and after SUM these unique revenues.
To find the Average value ; right-click the formula and select type (Average).
If you want to learn more; read these articles; Multi-select table fields and Data structure.