We want to populate a dropdown filter in Metabase using a MongoDB collection named "A", but only include records where status
is "active"
.
Right now, the dropdown shows all records, regardless of status.
Does anyone know how to use a custom MongoDB query to filter the dropdown values?
Right now, the dropdown shows all records, regardless of status.
Does anyone know how to use a custom MongoDB query to filter the dropdown values?