Hi
I have created filed filter for one of the column which is having almost 1500 values.
but somehow its only showing 9 to 10 values.
any idea what could be the issue
Please post "Diagnostic Info" from Admin > Troubleshooting, and which database it relates to for every single topic you create. That makes it much easier to understand and reproduce problems.
The Field Filter dropdown options comes from either values picked up during scan, or values directly from the data source - this depends on various things.
I don't know if you had the 1500 values constantly there or not, so you can try clearing the cache and scanning again via Admin > Data Model > (db) > (table) > (column) 
Hi ,
please find below details -
{
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:89.0) Gecko/20100101 Firefox/89.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9",
"os.name": "Linux",
"os.version": "5.4.0-1046-gcp",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"bigquery",
"h2"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.3 (Debian 12.3-1.pgdg100+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-05-27",
"tag": "v0.39.3",
"branch": "release-x.39.x",
"hash": "598a112"
},
"settings": {
"report-timezone": null
}
}
}
Also, since list was not populating i have selected list variable to display on x axis. so my x axis is shared between data and name of department.
Do we have any limitation to select x axis series
Attached the sample graph.
- i am looking for option to either display full list or at least normal search should be accessible if i put initial alphabet of respective organization. eg. as per shown in graph if i want to select EFG , entering E should suggest me to give all list of organization starting from E
- I am looking to limit the Y axis values only till 50%. How should i limit the values by giving minimum n max value.
@Prajakta2021 You would do that with a breakout. And the Field Filter. Have a look at the documentation:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html
https://www.metabase.com/learn/building-analytics/dashboards/filters.html
I have already added organization as field filter and display visualization as x-axis breakout. but somehow, my list of organization is not coming full. it shows me hardly 10-20 values in dropdown
How i will update metabase if i have connect it through google cloud.
using .jar
?
@Prajakta2021 I don't know how you're running Metabase, but you simply replace the JAR file.
Always have a backup before upgrading.
https://www.metabase.com/docs/latest/operations-guide/upgrading-metabase.html
@Prajakta2021 I have no idea how you have setup Metabase. You said you were using JAR before, but now you changed a Docker image.
But then revert to your backup.
I have deployed fresh metabase with new version. but still not able to see full list in drop down. By any chance is it because dashboard only display 2000 records at one time.
@Prajakta2021 So let's make everything very simple. Ignore dashboards, only look at the filter dropdown on the question.
And post the details from /api/field/123 where 123 would be the field ID - you can find that by looking in Admin > Data Model > (db) > (table) > (column) , and look in the URL.
1 Like
Thanks
Hi
I am facing same issue at question level now. I am not able to see the list in drop down. I have created sql question
Please find the path below -
admin/datamodel/database/4/table/72/1517/general
Below is diagnostic details -
{
"browser-info": {
"language": "en-US",
"platform": "Linux x86_64",
"userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:89.0) Gecko/20100101 Firefox/89.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9",
"os.name": "Linux",
"os.version": "5.4.0-1046-gcp",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"bigquery"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.3 (Debian 12.3-1.pgdg100+1)"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-06-15",
"tag": "v0.39.4",
"branch": "release-x.39.x",
"hash": "f538050"
},
"settings": {
"report-timezone": null
}
}
}
Unable to access link.
Since we were in hurry we drop that functionality