Hi there,

I'm having a hard time trying to join tables as needed to create a proper report.

I would say that my use case is quite basic, I'm using (from Desk) the Tickets, Tasks, and Agent tables.

I want to list all tickets with a custom boolean field (let's call it "To review?") set to true with their associated task (if there is any), as well as the name of the agent assigned to the task (not the ticket).

My problem appears to be that the join type is set for all paths and it's not possible to change the path order (switch tables from left to right and vice-versa).

I need a right join for the first path (Tasks > Tickets).

And I would actually need an inner join for the second path (Tasks > Agents) but it doesn't even exist in Analytics.

The report is working fine when I just have the Tickets and the Tasks tables. The problem is that whenever I add the "Agents.Name" field to my report, I then consequently need the Agents table, and the join is just not correct for what I need to achieve.

Did I miss something in my conception or is this a limitation of Zoho Analytics?

Best regards,

Cyrille