Relationships via a unique list of data - report breaks when addign data fields from the 2 queries

[Anonymous]

Hi,

Query 1: List of all Orders with Order No (non unique list of Order Numbers)

Query 2: Webpage Clicks data with Order No (non unique list of Order Numbers)

Custom Table: With list of unique Order Numbers from both of the above queries

Relationships:

Query 1 to Custom Table: Many to One Bi-Directional

Query 2 to Customer Table: Many to One Bi-Directional

In the report section when I add a table with data fields from both of the above queries it breaks. If data is present from only 1 query it works fine.

Not sure what is the mistake I'm making.

TIA for any guidance!

-Sid

[MFelix]

Hi @Anonymous ,

Believe your issue is with the Bi-directionalty, on this setup you need to setup one direction filter and then use the column from the custom table has your Order numbers.