New Channel Metric =
IF [Sold Vs. In-Force] = 1
elseIF [Sold Vs. In-Force] = 2
else null end.
Appreciate the response! I've tried the ATTR function before - but because there are multiple channels under the "Channel" Metric - it only produces one of the channel results (for ATTR it even lists "returns the value of the given expression if it only has a single value for all rows in the group" -- in this case I cannot group by Channel in calculations themselves.
Right. Whatever you pull from the secondary source has to be ONE VALUE (whether it's a SUM or AVG, etc.) ATTR ensures that as well.
So here's how you have to look at it: If you have multiple channels in the secondary source, which one do you want to see? There is no other option.
If you want to see multiple values, you have to re-shape your data, or make the secondary source the primary source, or ETL something different into the secondary data. ...
You said you tried blending on Channel. Why didn't that work? What happens when you blend on Channel AND Date?