Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Circular/ambiguous relationships

Good day fellow experts,

I am working on a dashboard where the customers of a company "Clients" are shown next to the Potential customers to obtain "Potentials", these two tables are related by a third table that geographically groups the companies of both tables "Geo_Iberia" (Ingnorar the table "RVL List, as it only adds details of sellers by region")

In addition, I have 2 other tables at the bottom, which serve to indicate the segment to which current customers belong. The problem is that I need both current and potential customers to be connected not only by geography (Table geo_Iberia), but also by segment (Table Segment_group). But this would generate an error due to circular/ambiguous relationships.

Please ask for help if you can indicate any way in which I can generate visualizations where information from both tables (customers and leads) is shown and that can be controlled by both filters (geographic region and segment).

1 Reply

  • All of these sound like dimension tables. Where are your fact tables?  What business questions are your reports trying to answer?