Forum Discussion
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
- lbendlin
Super User
All of these sound like dimension tables. Where are your fact tables? What business questions are your reports trying to answer?