Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

relationship setup

Hi,   how to easily setup the interaction between all of the visuals and charts. for instance i have 2 tables (Inbound and outbound) contains the same information.   I had to split this to 2 tabl...
Need Help
Show and Tell
Mond's avatar
Mond
Helper III
8 years ago

Create distinct list of HQ Regions from Inbound and Region table.

Join the new table with Inbound & Outbound.

create filter condition on the distinct region that was fetched from unique list.

 

Also make sure, you enable, cross filter direction on the join condition.

 

vjnvinod's avatar
vjnvinod
Impactful Individual
8 years ago

Mond

 

my table is inbound and Outbound, so i have

Created distinct list of HQ Regions from Inbound and Outbound table.

Joined the new table with Inbound & Outbound (as you see in my screenshot)

 

create filter condition on the distinct region that was fetched from unique list? what you mean by this, can you help?

 

 

  • Mond's avatar
    Mond
    Helper III
    8 years ago

    create filter condition on the distinct region that was fetched from unique list? what you mean by this, can you help?

    I meant to use this distinct region in your slicer (visual) for filter purposes.

    • vjnvinod's avatar
      vjnvinod
      Impactful Individual
      8 years ago

      Mond

       

      its already there as a dropdown, but my outbound values are not interacting with my other tables

      • Mond's avatar
        Mond
        Helper III
        8 years ago

        Did you set up cross direction on the joins.

         

        Have you reset the slicer (filter) once again