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.