Double counting is a common issue in database design. When joining several incorrectly linked tables, some records may be duplicated and counted more than once. There are several cases which might cause double counting, and there's no uniform or automatic solution to these cases.
Double counting issues might happen to you during the development of projects on the platform. We've added a warning mechanism that will inform you when there's a risk of double counting. Let's have a look at some possible cases that might cause this error.
Example data model
| Info |
|---|
The data model can be viewed in the application by hovering the Account icon on the bottom left of the Project page, and selecting Data model. |
...
| Info |
|---|
If you don't think you see your case listed here, contact us at info@cleveranalyticssupport@clevermaps.comio. Please note that your issue might not be 100% identical to the solutions described here, the solution lies in the principle of your data model design. |
...