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

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
Pretzel2

 

 

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

 

dimension1dimension2page views
PretzelBeer1

 

 

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:

 

dimension1dimension2pageviews
PretzelBeer1
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.