Hi! I’m having an issue with listing values in filter. Basically, I have native SQL question with a field filter on a categorical column. When I use the filter in the question, it provides a list of all the possible values for me to select from, which is what I want. However, when I put that question in a dashboard and then link a dashboard filter to it, it does not list values, and instead says “Enter some text”. What is really curious is that when I go to select a default value for the dashboard filter, it does show a list of values! Any help would be greatly appreciated.
Also, I’m using Postgres for the question, have set the column in the data model to categorical, and specified filters on it to list all values.
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.7+10",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.7",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.7+10",
"os.name": "Linux",
"os.version": "4.9.0-11-amd64",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"postgres",
"googleanalytics",
"snowflake",
"athena"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "11.8"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.8"
}
},
"run-mode": "prod",
"version": {
"date": "2020-12-03",
"tag": "v1.37.3",
"branch": "release-x.37.x",
"hash": "2f1e783"
},
"settings": {
"report-timezone": null
}
}
}