Please take a look at these articles as your starting point
If you have any questions please post them.
Yes I did go through all the links but had a hard time understanding , I am
calculating the MEDIAN AND COUNT from the primary data source the error is
throwing up on using the dimension from the secondary data source brought
into the filter . It is not used in the view the dimension filter. Can you
suggest any workaround ? Our goal is to calculate MEDIAN so cannot omit
On Wed, Feb 22, 2017 at 12:07 AM, Tharashasank Davuluru <
Can you post a sample workbook?
Not allowed to post.
On Wed, Feb 22, 2017 at 10:11 AM, Tharashasank Davuluru <
1 of 1 people found this helpful
Credits to Jonathan Drummey for the below workaround Cannot blend the secondary data source because one or more fields use an unsupported aggregation
This is a new complexity in Tableau v8:
In v7 and earlier, to blend we had to have the linked dimensions in the view, i.e. on Rows, Columns, Pages, or the Marks Card. This is called "DB1" for "Data Blending 1" by Tableau.
In v8, you can use that DB1 blending or the new "DB2" blending where A) the linking fields don't have to be in the view, instead you just click on the linking dimensions in the secondary in the Data Window, and B) you can control those linking dimensions on a per-worksheet basis. The one drawback is that DB2 blending does not support "non-additive aggregates" like COUNTD() and MEDIAN(). When you try to do that, Tableau generates the "Cannot blend the secondary data source because one or more fields use an unsupported aggregation" error, turns the offending pill red, and grays out the view.
It's hard to give an exact roadmap to a solution because blends are so dependent on the data structure of the different sources, defined data relationships, and the pills in the view. Solutions include avoiding DB2 blending and just using DB1 blending for your particular worksheet, using table calcs like SIZE(), using a custom blend, etc. There were a couple of techniques talked about last week in this Tableau blog post by Daniel Hom: http://www.tableausoftware.com/about/blog/2013/5/tips-tricks-alternatives-count-distinct-23253.