Forum Discussion
Unable to Filter Visual using Indirect RelationShip
Hi, Hoping to get some help from this wonderful community. Below is the snapshot of my data model Successorders => cases ( Many to 1 Single filter Direction) FailureOrders => cases ( Many to 1 Sin...
Hi SwatKat
1.I have the following question:
The lookup() function can only return single value, the relationship between the FailureOrders and cases is many-to-one, so when you use the funciton in case table, it cannot return the value, because there are multi related rows in FailureOrders table. How the column work, can you provide some sample output of the calculated column?
2.If you want to filter the column, try to change the filter direction to both between Customer and Acount table.
Best Regards!
Yolo Zhu