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

Adding a filter picker to a report

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭



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