cancel
Showing results for 
Search instead for 
Did you mean: 
Community_Admin
Community Team Member
Community Team Member

Analytical Need

There are cases where our data arrives in aggregate form, like in Google Analytics (where the lowest granularity level is daily). If we wish to free up clutter in the dashboard and prevent the user from figuring out which field comes from which table, we'll need to make some modifications.

 

Modeling Challenge

 

We will want to create a unification of tables in order to create a cleaner, simpler schema. However, if there are tables that are aggregating the same field but with different categories we cannot unify them since the measures in the dashboard will create incorrect results.

 

Solution

 

Create a union query for all the tables that are aggregating different fields with empty fields in the appropriate locations.

The resulting tables will be connected to each other via the possible dimensions (mainly date). In order to create a custom dimension, please see Creating a common date selection.

From this:

Community_Admin_2-1634724930802.jpeg

Into this :

Community_Admin_3-1634724930845.jpeg

Attachments

 - 811KB - Aggregate Facts.ecdata 

Version history
Last update:
‎10-20-2021 03:16 AM
Updated by:
Contributors
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Need additional support?:

Community Support Request