Forum Discussion
Helper IDate Table Won't link properly
Hi Spudder112
When you use dimension tables (in this case the date columns) you must always use the dimension table on your visualizations, in this case when you use your calculation with the data from your fact table you are always getting the same result because of the filter path between the transaction table and the date table.
On the one to many you have a filter that is coming from the date table to the transactions table, the other way around is not possible so it's like there is no relationship between the table and you get always the same result.
Not sure what you are trying to achieve with this visualization but you must use the Date from the date table and not the transcation date.
Super UserHi Spudder112
When you use dimension tables (in this case the date columns) you must always use the dimension table on your visualizations, in this case when you use your calculation with the data from your fact table you are always getting the same result because of the filter path between the transaction table and the date table.
On the one to many you have a filter that is coming from the date table to the transactions table, the other way around is not possible so it's like there is no relationship between the table and you get always the same result.
Not sure what you are trying to achieve with this visualization but you must use the Date from the date table and not the transcation date.