Custom Metrics in Data Studio Connectors not working properly
I would like to add values across multiple columns when using various Data Studio Connectors, like Facebook ads, Adwords, and Analytics, but the custom metrics do not calculate properly if any of the columns contain null values.
For instance, suppose I want to add multiple actions within the Facebook Ads Connector, such as Leads (form) + website leads, the results will look like this:
|Campaign||Leads (form)||Website Leads||Total Form Fills (Custom Metric)|
Is there a way to convert null values to 0 or some other way to get columns to add up properly?