9 Replies Latest reply on Oct 17, 2016 5:23 AM by Hildebrando Souza Jr

    Filtering across a blended dataset using a parameter

    Joe Proulx

      I have two tables - one is a database, the other an Excel file.

       

      Excel File (secondary datasource)

      PIN

      TeamName

       

      Database (primary datasource)

      PIN

      Total Hours Booked

      Lots of other fields...

       

      I have created a parameter based on the TeamName field, then created a calculated field like this:

       

      TeamNameParameter = ATTR(ExcelFile.TeamName)

       

      My thought was that I'd drag that up to the Filters and filter on TRUE, but it won't allow me to. I imagine it has something to do with the fact that it's in the secondary data source. Any workarounds? We were set to go live with Tableau 10.0 this weekend, but we pushed it back a month...otherwise I'd just use the cross-database join capability. But is there any way I can make this work now?