May 23, 2022

Google Data Studio - Blending Data Sources.

Here’s a quick one for anyone using Google Data Studio. When blending multiple data sources to calculate and display a total value (e.g. total conversions) the output will display “null” if one value returns zero.

To fix this, use the NARY_MAX function to return the maximum value of the input arguments.

https://support.google.com/datastudio/answer/7583429?hl=en#zippy=%2Cin-this-article

NARY_MUX Function!