Show value on series bug on latest period of combo chart

Bug reports
1

image
image1228×527 29 KB

image
image
image1390×533 27 KB

I'm creating a combo chart for month as X-axes and activate show value for series for one of the 2 visualized metrics. It is showing 0 for the latest month (1st pic). The actual value is not zero when I'm using table visualization (2nd pic). It is showing correct number when I remove the other metric (3rd pic). Anyone experiencing the same issue?

2

Hi @irulf
Post "Diagnostic Info" from Admin > Troubleshooting.
I cannot reproduce, but something makes me think that you're seeing this issue:
https://github.com/metabase/metabase/issues/16523

3

Yap, it seems to only happen when too low value metric and too high value metric were combined in the same chart. For now I divide the high value with some number (within the SQL Query) so the gap between the two metrics were smaller, then I multiply it with the same number on data setting to get it back to its actual number, so far it works fine using this workaround
image

image
image1843×487 41.7 KB

Thanks @flamber for the response, Below is my diagnostic info for further investigation

{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:89.0) Gecko/20100101 Firefox/89.0",
"vendor": ""
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.11+9",
"java.vendor": "AdoptOpenJDK",
"java.vendor.url": "https://adoptopenjdk.net/",
"java.version": "11.0.11",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.11+9",
"os.name": "Linux",
"os.version": "4.14.232-176.381.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"mysql",
"sqlserver",
"h2",
"redshift"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "12.3"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.2.18"
}
},
"run-mode": "prod",
"version": {
"date": "2021-05-17",
"tag": "v0.39.2",
"branch": "release-x.39.x",
"hash": "b0d9436"
},
"settings": {
"report-timezone": "Asia/Bangkok"
}
}
}

4

@irulf Yep it's definitely that issue. Upvote by clicking :+1: on the first post