Hello. I have a column A in one table and column B in the other table. The values of column B depend on A. When I join the tables in a query and add a filter for both column A and B and link filter B with A (in the master dashboard), it works for all values of A except one (let's call that value G). So for example, I set filter A to X, Y, Z and it works fine, i.e. B's values change accordingly. But when I set filter A to G, B shows nothing (as can be seen in the screenshot below.
Can anyone please tell me what could be wrong, with the filter or the underlying data, to lead to this behavior?
Hi @sanabasharat
Post "Diagnostic Info" from Admin > Troubleshooting.
How many distinct values do you have in filterA and filterB?
It's the first time I've heard about a behavior like this. I'm wondering if filterB's values are even updated, so it has what should be reflected when "G" is set in filterA.
{
"browser-info": {
"language": "en-PK",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.67 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "1.8.0_312-heroku-b05",
"java.vendor": "Oracle Corporation",
"java.vendor.url": "http://java.oracle.com/",
"java.version": "1.8.0_312-heroku",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "25.312-b05",
"os.name": "Linux",
"os.version": "4.4.0-1103-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
},
"metabase-info": {
"databases": [
"h2",
"postgres"
],
"hosting-env": "heroku",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.9 (Ubuntu 12.9-2.heroku1+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.23"
}
},
"run-mode": "prod",
"version": {
"tag": "v0.41.4",
"date": "2021-12-10",
"branch": "release-x.41.4",
"hash": "471cfb9"
},
"settings": {
"report-timezone": null
}
}
}
There are 65 distinct values in A, and 20 in B.
But the thing is, for all the other values of A except value G, the linked filter B is working fine (dropdown shows values according to selected A values).
Which makes me think there is something wrong with value G (but can't figure out what it can be).
@sanabasharat There has been a lot of changes in newer versions of Metabase.
Try looking in the query log on Postgres, so you can see the query Metabase uses, when you do the selection of "G" vs the working values.
