Data Studio: Convert NULL Values to Zero for Calculated Fields

Data Studio May 23, 2021

Occasionally you may experienced that a calculated field returns "No Data" when one of the field is is NULL.

Taking an example here:

I have a blended data source combining Facebook Ads and Google Ads. Of which Facebook data is available only from current month. So I create total amount spent I get the value correct for current month;   but data return "No Data" for previous month as Facebook spend was NULL.

To overcome this, at data studio we can use a function named NARY_MAX

Function will return "0" instead NULL without breaking the calculated field.

Tags