Insight Reporting | Adjusting Totals for Tables and Performance Tiles
When viewing Insight report totals for unique metrics, you may have encountered a scenario where the total value is not displaying the sum of the column as you might be expecting it to.
In the example report below, a total of 11 unique opens is displayed in the report when we may be expecting the total to be 15 instead (4+1+5+5=15).
The following article is helpful to contextualize how the unique total is being calculated by default:
"Demystifying unique totals" https://community.oracle.com/customerconnect/discussion/696464/
If you would like your report to display the total sum instead of the aggregate for unique contacts, you can use one of the following approaches (note: an Analyzer license is required to edit reports):