Hi Community, I am very new to Dashboarding, I am running into a weird issue where I have 3 data sources all on Google Sheets that I can connect to charts and they work great - as intended, But I have a requirement where the data from these 3 sheets need to be shown on the same page and be able to filter by the same control. I figured out that you need a blend to do those and have all charts on that page and the control be connected to the blend.
My issue is when I go ahead and blend the 3 data sources together I get this error
"The underlying data has changed. Please notify the data source owner to refresh." Error ID: a2ff4a53
I can't seem to figure out what I did wrong? Can someone else point me in the right direction. I need to show this dashboard in less than 12 Hrs ๐ต
If it is of any significance they all have a common field called `Distributor` which I use to do the joins.
the last 2 tables are actually the same data source but I couldn't get all the dimensions so I have to connect it again and grab the rest (Tried it with the same data source inside Looker Studio as well as connecting the Google Sheet twice as 2 different data sources - Both had same results).
Thanks in Advance for any help, you will be a life saver ๐
If the only reason youโre blending is to be able to filter all 3 sources by a single field, this can be done with โbridge fieldsโ and no blending. Hereโs an awesome tutorial: https://youtu.be/0ZGUx76CrkM?si=0ShGmKuwcE03dhpf