Hey I'm trying to divide the count of one table by the count of another table for records that match the timeframe and customer selected in the filter by the user. I wrote a native query using variables that runs well in the editor but says there's a problem displaying the chart when I add it to a dashboard, and when I try to connect it to the dashboard filter it says there are no valid fields to filter on.
I'll add the query/results below. I set the customer variable as a field filter and connected it to the name column in the customer chart, and I set start_date and end_date as date variables.
Hi @kdonnelly
Post “Diagnostic Info” from Admin > Troubleshooting.
And look for a more detailed error in Admin > Troubleshooting > Logs.
right sorry! here’s the diagnostic info and i’ll take a look at the logs now!
{
“browser-info”: {
“language”: “en-US”,
“platform”: “MacIntel”,
“userAgent”: “Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.192 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.10+9”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.10”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.10+9”,
“os.name”: “Linux”,
“os.version”: “4.14.200-155.322.amzn2.x86_64”,
“user.language”: “en”,
“user.timezone”: “GMT”
},
“metabase-info”: {
“databases”: [
“redshift”,
“h2”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “11.7”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.18”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2021-02-19”,
“tag”: “v1.38.0.1”,
“branch”: “release-x.38.x”,
“hash”: “0635914”
},
“settings”: {
“report-timezone”: null
}
}
}
Okay I went through the logs and I’ve ran and reran versions of this query many times trying to get it to work so I’m not 100% sure this error is the one you’re looking for but I think it is because the only other error message I saw in the logs was about missing parameters which I would get if I either didn’t make date optional or I didn’t select a start and end date.
But here’s the error -->
:error “Error determining value for parameter”,
@kdonnelly But you’re using two simple Date filter on the question, right? So when you try to add filters on the dashboard, you can only use “Single Date”.
I don’t fully understand that it shows an error on the dashboard, but nothing in the logs.
The error you’re posting seems to be unrelated to this.
