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
4.2K members online now
4.2K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Adding a filter picker to a report

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi

 

This might be a simple question so apologies.  I have a report consuming google analytics data for multiple intranet sites.  I have created a number of pages which are each filtered by a page filter 'include field contains x'  where the field I am using is 'page' and x is simply part of the very long page path which contains the country name.  e.g. Mysite-Japan.  It is working fine with an index page that takes the user to the respective page for each country site - but the report is now 14 pages.

 

 I can't help feeling it would be a lot better to have a single page with a drop down where the user could select which page filter to apply - in effect a 'filter picker' or a 'filter filter' !

 

Am I approaching this the wrong way?  I have tried adding a filter control to the first page and creating a new dimension which picked out the parts of the page urls (effectively duplicating each page filter) but I cannot work out the REGEXP_EXTRACT function.

 

Any ideas gratefully received