3 Replies Latest reply on Apr 13, 2018 5:03 AM by Tushar More

    Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending

    Bhavana Khairnar

      Hello Everyone,

       

      I am using one data source which is a LIVE connection and I have duplicated same data source , the reason behind duplication is i want to have total of category which will be constant and it will not change even if i filter out that category. So the total I am calculating in secondary data source and filter on the same category I have put from primary data source. Here blending I have done on date so even after filter my total value will not change.

       

      Both of my data sources have LIVE connection. But when i drag this total from secondary data source I get this error " Cannot blend the secondary data source because one or more fields use an unsupported aggregation" when Data Blending" But for total I am simply using SUM([ABC]), but my ABC is already a calculated field.

       

      I am not getting why am i getting this error, as I am not using any COUNTD() or MEDIAN() function. then why I get this error?

       

      Does anyone think I should make EXTRACT of both of these connections ? Is that is where I am facing this problem ?

       

      I am using Tableau Desktop Version 10.3.5

       

      Thanks in advance.