Blending will not allow you to obtain the correlation coefficient using a calculated field, you could join the data sets together if that's the objective.
In the current state, to investigate the correlation between the cost and the other awareness metrics, you can create multiple scatter charts and add trend-lines from the analytics pane to the same worksheet. The set-up would look something like the following:
I noticed you are blending the data on date. This raises a question are you trying to investigate the relationship between the metrics based on the month year values? Or is it media type? If it is the latter, you will need to blend/link the data at that level too!
Hope this helps!
Hi Sasha, thank you for your answer.
The sources are not blended through media type because awareness is not mediatype-specific.
The relationship is through date because he correlation should basically say "when we spent more on media, this and this happened with awareness".
I'll try and merge them together ^^