How to filter Analytics data in Data Studio with parameters?

Question

I'm making a report in Data Studio using my Analytics data, and I'm having some trouble finding out how to filter it. Here is what I need to do: I receive a "user" parameter in the URL, and I need to filter my "username" dimension with it. I want to make some kind of filter in the report, like Include usernameDimension = userParameter.

question from:https://stackoverflow.com/questions/65939295/how-to-filter-analytics-data-in-data-studio-with-parameters

Answer 1

For some limitation in DataStudio, currently it is not possible to directly use Report URL parameters for filtering reports (when you create a filter, it only allows you to select fields, not parameters). However, it is possible to 'hack' this limitation with a new field that references the parameter.

Create a new boolean field called my_filter (or something you wish) with this expression:

field_i_want_to_filter = my_parameter

Then, just create a new filter in your report using this field, with the condition my_filter is true.