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 ChrisAZ
There really isn't an active relationship between Samsara - KM and DateTable because you can't create one for them due to the direction of the relationship between Vehicle Info and Samsra - KM
Change the direction of the relationship then create the relationship.
Please note that at the category level, you will see the total for january since there is no relationship between Shop Parts - Fleetio and Samsara - KM
I was able to add the relationship to Date by changing the other one but it sounds like you are stating I still won't be able to see the data line up by the correct month? It is still showing data for January showing up as August, etc.
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.
But I already do have a relationship on the date field between my date table and the Shop Parts table. Is there supposed to be something else as I thought that would be enough for it to make the connection.