3 Replies Latest reply on Jul 6, 2018 1:55 PM by Deepak Rai

    Cannot blend the secondary data source because one or more fields use an unsupported aggregation.

    Diego Navarro

      Tableau Desktop 2018.1 Connected to Tableau Server as Main DS and Live Connection to an excel file as secundary DS

       

      Hello guys

       

      I know this is going to be kind of hard to fully understand since I am not able to upload the workbook because of the confidential data and the (I think) inherent nature of the issue below, but let's give it a try and see your thoughts

       

      I am building a report that provides custom drivers depending on the user selection as following (See attached PNG 01 for visualization):

       

      Yield = Volume / Surface                        (PNG 02)

      where

      Volume = Crates, Pounds or Kgs           (PNG 03)

      Surface = Acres or Hectares                  (PNG 04)

       

      As soon as I bring the Yield to the Measure Values the Data Table gets grayed and the error text box shows up (PNG 06)

      The thing is that if I bring the Yield to another Sheet everything is ok (PNG 07). I know this issue is caused because of the mix of measures from the different data sources but had no idea how to solve it

       

      Also, If I try to get YTD Surface then I get error (PNG 09) but when I try the exact same formula for volume I get no issues at all (PNG 08)

       

      If I'm missing something please let me know

       

      Any Comment or question will be appreciated

       

      Best Regards