3 Replies Latest reply on May 8, 2018 5:56 AM by Mayank Mamgain

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

    Mayank Mamgain

      Hi everyone,

      I'm trying to blend two data sources on a single field, say 'Program Description'.

      From my primary data source I have a dimension in columns say 'Customer Segment'.

      From my primary data source I have a measure in rows, say 'Measure, which is 'distinct count of Pol Number' or 'sum of Premium' depending on a boolean parameter's values (TRUE or FALSE)

      From my secondary data source I have a measure 'Target' which is the average of 'Target'.

       

      Is this a property of data blending that you cannot toggle measures where there is a distinct count involved? But it still works when i use it independently?

      For example:

      1. Does not work

      if [PC/WP]=TRUE then COUNTD([Policycounter])

      else SUM([Prem Written])

      END

       

      2. Works

      if [PC/WP]=TRUE then COUNT([Policycounter])

      else SUM([Prem Written])

      END

       

      3. Works

      COUNTD([Policycounter])

       

      Please help.