1 Reply Latest reply on Oct 16, 2019 2:16 PM by Eman Alvani

    Calculated Fields with Blended Data

    Alex Dowd

      Hello all,

       

      I know this is probably simple but I don't have much blending experience so here goes: I have 2 data sources successfully blended and am wanting to write a calculated field to measure attrition as a percentage. I have the total number of headcounts on one data set, and the number of attritions on the other so I am trying to write

       

      number of records (datasource1)/total headcounts (datasource2) and i get the red pill telling me "cannot blend the secondary datasource because one or more fields use an unsupported aggregation". Can anyone offer a solution? The total headcounts is a calculated field on datasource2, in case that helps.