Forum Discussion

PhilSmith's avatar
PhilSmith
Icon for Helper III rankHelper III
1 year ago
Solved

Adding Relationship kills results, Why does this relationship break things?

I have a table visual that pulls data from Budgets.  When I create a relationship to  Accounts, that visual goes blank.  It shouldn't. There are perfect matches between the two columns being related...
Need Help
  • andrewsommer's avatar
    andrewsommer
    1 year ago

    The issue is not the relationship it is the filters you have set.  Your dataset does not contain any rows that have the combination of Account[account] in (8170,8175), Budget[budegt ID] = 13 and budget_name = 2025.

     

    When I look at your data for rows for those accounts and those budget IDs all of the budget names are blank which is why your table is blank.

     

    Please mark this post as solution if it helps you. Appreciate Kudos.

     

andrewsommer's avatar
andrewsommer
Icon for Super User rankSuper User
1 year ago

The issue is not the relationship it is the filters you have set.  Your dataset does not contain any rows that have the combination of Account[account] in (8170,8175), Budget[budegt ID] = 13 and budget_name = 2025.

 

When I look at your data for rows for those accounts and those budget IDs all of the budget names are blank which is why your table is blank.

 

Please mark this post as solution if it helps you. Appreciate Kudos.