11 Replies Latest reply on Jun 23, 2015 3:38 AM by Norman Dilthey

    Filter another table using data blend.  Global filters don't affect other table.

    Chris Rains

      I'm working with data blending in conjunction with global filters.  I have two tables at different grains, and I want to use Tableau's data blend ability. The two link by a common key field (which is a foreign key in the second table).  I need to show the distinct count of records in the second table, and display that count in the UI.  But, that count needs to match the current filters and view of the first table (i.e. the count should be reduced by quick filters that affect the first table).  In other words, I want filters in one table to reduce the view of data for the other table, and allow multiple selections or filters at the same time.

       

      Any ideas are appreciated!

       

      Chris Rains