Forum Discussion
Calculation problem
Hi,
The reason is you dont have any realationship between your Date table and your "Samsara - KM" table. Hence date is not getting filtered out. Please add a relationship using date column.
Hope this helps to resolve your problem. If it does, please mark it as solution, thanks!
Your datetable should be able to filter your KM fact table once a relationship has been established but since there is no relationship between that and Shop Parts - Fleetio, you will see the same value at the category level in your matrix. See the cells highlighted in yellow.
Hi,
The reason is you dont have any realationship between your Date table and your "Samsara - KM" table. Hence date is not getting filtered out. Please add a relationship using date column.
Hope this helps to resolve your problem. If it does, please mark it as solution, thanks!
So I had attempted to set this already and thought it was in place. I went back in and set it again, but after I click Save, it does not seem to save the relationship. Any idea why? I get no error.