AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
3.4K members online now
3.4K members online now
Ask questions about Data Studio
Guide Me

Reporting on an unused dimension

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I'm trying to figure out how to report on a dimension that is not populated. I haven't solved except manually outside of Google Data Studio.


Pageview 1:

ga('set', 'dimension1', 'Pretzel');
ga('set', 'dimension2', 'Beer');


Pageview 2:

ga('set', 'dimension1', 'Pretzel');
ga('set', 'dimension2', '');


If I pull pageviews on dimension1 alone, I get:


dimension1page views



But if I pull page views on dimension1 and dimension2 I get:


dimension1dimension2page views



Usually in this case, I would just populate the blank value with a 'NA' if I had the option. Does anyone have a solution to get to:


Pretzel 1



... using a calculated field or filter? I tried IS NULL on dimension2 and excluding populated values in dimension2 and nothing worked as long as I used dimension2.