Forum Discussion
How can I adjust data model to avoid triangular relationship
Hi - Data model question... I have a fact table of usage/activity data containing the user, date, and location of use. I have dimension tables for location, date, and user details. ...
Billiam864 I don't know specifically what visualizations/calculations you are having problems with. But you can form relationships between your dimension tables via measures, for example. This would be a lot easier with sample data and expected results.
Thanks Greg, I've tried to attach an excel file to help, but appear not allowed. Photos are provided instead. I unfortunately cannot attach BI data (due to scale and sensitivity). There are 100's of various visuals across many dashboards connected to this data, so I'm trying hard to focus on the core data model, as opposed to getting lost in the weeds. Does the excel help?