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