Enforce a join to use in Insight

srini_ch — Mon, 21 Nov 2022 17:50:06 GMT

Hi Community,

Scenario: Let's consider that we have tables A, B, C, D, and Z and the joins between them are as follows and are in the same order as follows,

C --> Z

D --> Z

A --> Z

B --> Z

We have other joins between tables A, B, C & D. We have all these tables being used in the insight, where the insight uses C --> Z join, but I want to enforce the join A --> Z to be used. I tried adding the base column, but it didn't work.

Is there any other that I could use?

Thanks,

Srini

Re: Enforce a join to use in Insight

Wadeyy03 — Thu, 06 Apr 2023 14:16:00 GMT

Maybe implement an Alias table for the same and then setup a join and then enforce the said join.

topic Re: Enforce a join to use in Insight in Dashboards & Analytics Discussions

Enforce a join to use in Insight

Re: Enforce a join to use in Insight