Dashboard filter doesn't show the dropdown list in joined data

1

I created a card in the Metabase dashboard based on the data joinded by two table:

The first table (let's call it DB1) includes the following columns:

  • Account
  • Name
  • Group

The second tabel (let's call it DB2) includes the following columns:

  • Email
  • Number of messages
  • Time sending message

I joined DB1 with DB2 by indicate that column Account in DB1 equals column Email in DB2.

Then I created a Dashboard filter in type Categories, filter type "A list of all values" for the column "Group". The filter was successfully created but the filter doesn't show the dropdown list of value.

What should I do?

2

Hi @Nghia1304
You need to set the filter type for all fields. Have a look here:
https://www.metabase.com/docs/latest/troubleshooting-guide/filters.html

3

Sorry I don't understand what you meant. When I go to Admin panl > Data Model, the fields already have the type "Category".

4

@Nghia1304 Both fields has to be "A list of all values"

Post "Diagnostic Info" from Admin > Troubleshooting.

5

All fields already be "A list of all values" though. :sweat_smile:

6

@Nghia1304 Post "Diagnostic Info" from Admin > Troubleshooting.

7

Here it is:

{
  "browser-info": {
    "language": "en-US",
    "platform": "Win32",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/99.0.4844.51 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.5+10",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.5",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.5+10",
    "os.name": "Linux",
    "os.version": "4.14.262-200.489.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "GMT"
  },
  "metabase-info": {
    "databases": [
      "athena",
      "h2"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "12.5"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.8"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2020-04-10",
      "tag": "v0.35.2",
      "branch": "release-0.35.x",
      "hash": "f3b2857"
    },
    "settings": {
      "report-timezone": "Asia/Tokyo"
    }
  }
}
8

@Nghia1304 You should upgrade immediately: https://github.com/metabase/metabase/releases/latest