Blended Data Aggregation - How to fix "No Data" in Data Studio?

If you are working in Data Studio, then it is almost certain that one way or the other you might have faced a challenge around "data blending", especially fixing "No-Data". The issue normally arises when you find two metrics, in two separate data sources and one of the the data is showing "0", which ultimately push the sum result as "null". One of the metrics might be showing “0”, but there are chances that this might reflect some numbers in future, so somehow we cannot ignore that. So, let’s figure this out, how to build the SUM function around NARY_MAX with an example.

Metrics from the original data source(s): Metric 1: 100, Metric 2: 0

In the next step, we will pick both the metrics and blend them. (since Data Studio blends are a left join, so let’s assume Metric 1 with the value on the left).

Further, let me pull both the metrics, but from the blend.

Metrics from the original data source(s): Metric 1: 100, Metric 2: 0

Metrics from the Blend: Metric 1: 100, Metric 2: No data

The data in Metric 2 was originally “0” in the Data Source, but once I use blend, I get the result as “No Data”. Here the common challenge or issue one might face is around the summation part, where "No Data" is going to render the entire formula as "No Data". Now this is also out of our reach, so we have to look for some other alternative.

After research and checking multiple solutions, finally I have the solution to this, i.e., "NARY_MAX". The NARY_MAX function returns the maximum value of the input arguments. NARY_MAX is similar to MAX, except it allows you to compare multiple values. So here stands the formula, which is going to return the max of two arguments.

NARY_MAX (Metric 1, 0) + NARY_MAX (Metric 2, 0)

With this, it will now generate the correct result for the above example, i.e., 100. So for any question around Data Studio blend that is showing "No Data" instead of "0", please refer to the above solution.

-----------------------------------------------