Forum Discussion

bourne2000's avatar
bourne2000
Helper V
3 years ago
Solved

How to make relationship?

Hi   I have three tables called project started, project finished and date table     Project started and Project finished has been connected through date table. Project started table has t...
Need Help
Show and Tell
  • vicky_'s avatar
    vicky_
    3 years ago

    I believe this is happening because of the direction of your filters. Notice that the arrows on the lines point away from the date table. This means that the filters applied to the date table will filter the other tables. But the project code doesn't exist in the date field.


    I think you can either change the cross filter direction to both ways (double click on the relationship line to get this popup and then select cross-filter direction both

    Or you can create a relationship between the project code fields of the two tables.

vicky_'s avatar
vicky_
Super User
3 years ago

I believe this is happening because of the direction of your filters. Notice that the arrows on the lines point away from the date table. This means that the filters applied to the date table will filter the other tables. But the project code doesn't exist in the date field.


I think you can either change the cross filter direction to both ways (double click on the relationship line to get this popup and then select cross-filter direction both

Or you can create a relationship between the project code fields of the two tables.