Transer data between data set A, controller and dataset B

[brown_chair]

I have set up two datasets in Looker Studio based on custom BigQuery query.I am using a controller to allow the user to select options from the given choices. The response is received in a variable in the first dataset. I want to pass the variable’s response to the second dataset because I have a complex query there, but I'm unable to do so. I would appreciate the community’s help

[Mehdi_Oudjida]

@brown_chair ,

Dynamic parameters are not available for the moment in Looker Studio. So you need to change your data model to merge the 2 data sets in one unique data source and create a field for your variable to be apply to use it for a control filter. The merging can be done upstream in BigQuery with a view or downstream with a custom query joining the data sets.

PS: If you use a custom query for aggregation considerations, be sure to authorize only one selected value in the control filter and define a default selection.

Mehdi