1 Reply Latest reply on Sep 14, 2018 3:42 AM by Jim Dehner

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

    ROBEMIE ORPILLA

      Hi All!

       

      I would like to ask for your help, I do have two data sources: BI Cube (primary source) & Excel file (secondary)

       

      BI Cube Data
      1 pc. Chicken + Choice of Drink
      Burger + Choice of Drink
      Spaghetti + Choice of Drink

       

      Excel
      Excel
      1 pc. Chicken + Choice of Drink1 pc. Chicken - VM
      Burger + Choice of DrinkBurger - VM
      Spaghetti + Choice of DrinkSpaghetti - VM

       

      The purpose of excel file is to map BI Cube Product Name ( column 1) to Marketing Name (Column 2). This has been successfully mapped in Tableau.

      BI Cube data which is the primary source contains Actual Measures such as Quantity; Calculated Measures: Average Daily Quantity.

       

      Quantity was successfully shown in Tableau:

      BI Long Name
      Marketing NameQuantity
      1 pc. Chicken 1 pc. Chicken - VM3000
      Burger + Choice of DrinkBurger - VM800
      Spaghetti + Choice of DrinkSpaghetti - VM1000

       

      However, when I will drag the Average Daily Quantity as additional measure, error displayed: Cannot blend the secondary data source because one or more fields use an unsupported aggregation".

      I cannot go on with my report because of this error?

       

      Appreciate your help.