'Data studio: Calculate a metric if a non aggregate value is XYZ
So I have the following data
| Channel | Spend |
|---|---|
| 100 | |
| 100 | |
| 110 |
Now I want to add a calculated field where final spends are calculated with 10% added to all channels except LinkedIn. So when I add the following calculated field
Final Spends
CASE
WHEN Channel = "LinkedIn" THEN Sum(Spend)+(Sum(Spend)*.10)
ELSE Sum(Spend)
But the above is throwing me following error
Sorry, calculated fields can't mix metrics (aggregated values) and dimensions (non-aggregated values)
Please let me know what to do
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|