Forum Discussion

vlad_drigin's avatar
vlad_drigin
Frequent Visitor
5 years ago

Interaction between 2 visuals

I have a report page that has 2 tables:

Table 1:

Table 2:

I have applied some filters on the 2nd visual (table 2), however, I cannot apply the same filters to table 1.

I want table 1 to only display companies that are in table 2.

Is there a way of doing this?

Thanks a lot!!

 

4 Replies

  • That's what a data model is for. Have you connected these tables?

    • vlad_drigin's avatar
      vlad_drigin
      Frequent Visitor

      Both of these tables (visuals) are made out of the same tables in data model, which are connected. In my question I mean table as a visual. When I apply a filter to one visual, I want all of the companies that are not in visual 2 to disappear from visual 1.

      • lbendlin's avatar
        lbendlin
        Super User

        If the visuals feed off the same tables then that filtering would happen automatically unless you explicitly disabled interactions between visuals. Do you remember if you did that maybe?

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi vlad_drigin 

    I have a question that why you cannot apply the same filters to table 1 ? As you said , the two visuals are from the same table with same fields. If you filter table 2 ,the data in table 1 will also be filtered .Unless you turn off the interaction between two visuals and forgot to turn it on .

    You can check the interactions in Format => Edit Interactions .

    Best Regards

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.