Date Linked Filter Not Working in Dashboard

I have a couple of dashboards. One is using a Notebook Query and the Other a Native SQL Query question. Both are behaving in the same way as it pertains to linked filters. There are three filters, Date-Time, AccountID, and WebaclID. If I link WebaclID to AccountID, it correctly filters the WebaclIDs based on what AccountIDs are selected. The user can select a Date-Time range and the results are displayed.

However, if I try to link AccountID to Date-Time, no values are shown when the user sets a Date-Range and then tries to pick AccountIDs. The same result is seen when I link WebaclID to both Date-Time and AccountID, no values for WebaclID are shown.

WebaclID and AccountID are both configured as Category and Dropdown list.


image
Date-Time points to partition_date_hour with the following metadata configuration:

This is the dashboard which requires all filters to be set before display results.


This is what happens when a date range is set.

Any ideas on how to get this working?

Here are our instance details:
{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36 Edg/121.0.0.0",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.21+9-LTS",
"java.vendor": "Red Hat, Inc.",
"java.vendor.url": "https://www.redhat.com/",
"java.version": "11.0.21",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.21+9-LTS",
"os.name": "Linux",
"os.version": "4.14.273-207.502.amzn2.x86_64",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"h2",
"athena"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.12"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.6"
}
},
"run-mode": "prod",
"version": {
"date": "2024-01-05",
"tag": "v0.47.11",
"branch": "?",
"hash": "51935b1"
},
"settings": {
"report-timezone": null
}
}
}