1 of 1 people found this helpful
One question are you using Data blend, means are you using two different data sources and creating relationship. I think your filter field is coming from two different data sources, can you try to ensure that you have a one to many relationship within the two sources also instead of using data blend if both the sources belong to same db and server try using joins in the data source or use a custome SQL.
Yes it coming from two different data sources but there are no relationship between them.
Dashboard 1 - Source 1 (Summary Table). It got many aggregations
Location , Group, ProductAMonthlyrevenue, ProductBQuarterlyRevenue, ProductCYearlyRevenue
Dashboard 2 - Source 2 (Summary Table)
Year, Month, Location, Group, MeasureType, Amount (here measure type = ProductAMonthlyrevenue, ProductBQuarterlyRevenue, ProductCYearlyRevenue)
I want to have a dashboard Action where click on say ProductCYearlyRevenue to display all the relevant information from source 2
Is here any relationship that can be built between the two different sources in the data. I can see that Location and Group dimensions are common in both the sources. Can't you create blend the data using those two. You need not worry about the duplication of data as in tableau data gets blended after it is aggregated the only thing you have to keep in mind is that Tableau only supports one to many relationship and not many to many. A relationship is required is definitely required to filter data among 2 different sources, because till the time there is no relation Tableau will never be able to identify which rows to filter from the second data source.
Would it be possible for you to share a sample packaged workbook. If data confidentiality is an issue then below is a post which will help you understand how you can anonymise you data to share on tableau forums.