Forum Discussion

ginalu's avatar
ginalu
Helper I
2 years ago

Unable to Filter Data Accurately

I used UniqueOrgs to filter a specific value, but results for values outside of this selection (e.g., Kevin) are still appearing. I have already created relationships between these two tables, so theoretically, UniqueOrgs[org_id] should equal LESSON[org_id]. In the visual, both columns should match for the data to be displayed?

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ginalu

     

    The relationship you created is based between UniqueOrgs[org_id] and LESSON[org_id], and you are referencing the org_name column in the table.

    Refer to below demo:

     

    Best Regards,
    Adamk Kong

     

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

    • ginalu's avatar
      ginalu
      Helper I
      2 years ago

      Hi Anonymous ,

       

      Thank you for your responsed. There is a relationship between three tables. Although org_name isn't the primary key, it comes from the same source. Are there any potential issues I might have missed?