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.