I connected looker studio to mysql database and i have five tables, all tables are connected with their primary keys which is employee id, i have blended data together on looker using employee id and even with the my charts wont interact. the charts connected to the left table interact perfectly but the the right table charts does not filter the left table chart. what can be done ?
If you have charts that only use the left table, they won’t listen to the right table.
You have to create charts that use the blended table - then Looker Studio will treat it as a single table with fields from the left and right and tables.