Greetings and Happy New year,
I found a small bug in charting. Seems if there is a select item in the output that is not part of the chart visualization selection, the caption reports with incorrect field label for the field that is not represented in the chart visualization.
Using latest Metabase.
{
“browser-info”: {
“language”: “en-US”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36”,
“vendor”: “Google Inc.”
},
“system-info”: {
“file.encoding”: “Cp1252”,
“java.runtime.name”: “Java™ SE Runtime Environment”,
“java.runtime.version”: “1.8.0_271-b09”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “http://java.oracle.com/”,
“java.version”: “1.8.0_271”,
“java.vm.name”: “Java HotSpot™ Client VM”,
“java.vm.version”: “25.271-b09”,
“os.name”: “Windows 10”,
“os.version”: “10.0”,
“user.language”: “en”,
“user.timezone”: “America/Los_Angeles”
},
“metabase-info”: {
“databases”: [
“sqlite”
],
“hosting-env”: “unknown”,
“application-database”: “h2”,
“application-database-details”: {
“database”: {
“name”: “H2”,
“version”: “1.4.197 (2018-03-18)”
},
“jdbc-driver”: {
“name”: “H2 JDBC Driver”,
“version”: “1.4.197 (2018-03-18)”
}
},
“run-mode”: “prod”,
“version”: {
“tag”: “v0.37.3”,
“date”: “2020-12-03”,
“branch”: “release-x.37.x”,
“hash”: “2f1e783”
},
“settings”: {
“report-timezone”: “US/Pacific”
}
}
}
Hi! I tried to reproduce your issue locally with a SQLite database and a simple query (not as complex as yours as I don't have a similar dataset) and I couldn't find the issue. Can you please upgrade to the latest version (0.37.4, you are in 0.37.3)?
also: which visualization are you using?
regards,
Luis
Hi Luis, upgraded Metabase engine and retried same issue, although some similar charts don’t have the issue. Next few days I will try to zero in on the conditions that reproduce the error. This is a line chart .
Chuck
