Value NULL for cross data

Looker Q&A Looker Studio
,
1

Hello! I need help with putting caption in values who doesn’t appear in the cross data

example;

table A:

Value , Name , Country A

and

table B:

Value B, Name B, Country A

Using Country A from both

To cross the data with “Country A” in both, and we got everything ok. But in “table B” there is some data missing because it wasn’t created yet or blank value and this value in “table A” is not null. How can i can rename this “blank value” to something like “still missing”?

2

What about a calculated field that checks for the nulls and replaces the valueB with a string? Something like this:

If( valueB is null AND valueA is not null, “still missing”, valueB)