I have 2 tiles on my looker dashboard 1: Top 10 decliners (First chart) 2: AVG TINT for top 10 decliners (Second chart).
This info is coming from a single explore which is generated using derived table i.e. Top 10 decliners will be dynamically identified between the 2 dates selected by the user.
I have issue with the second chart where I just want to see info for Top 10 decliners accounts but as of now info is shown for the accounts with max TINT as shown in chart 2.
Questions: How can I apply filter in second chart to show AVG TINT only for the accounts listed in chart 1?
