i'm creating a line chart with all values between 1.0 and .7. For any period that we don't have information (null), Metabase is assigning a value of 0. Because of this, I can't scale my graph to have a max of 1.00 and a min of .70. Is there anyway to get around this so I can scale the graph appropriately?
Hi @grihol
Post "Diagnostic Info" from Admin > Troubleshooting.
It's not obvious what you have defined the "Replace missing values with" setting to under Display.
But are you sure you're returning null and not 0? Try viewing the results as a table.
I formatted the graph to 'show values at data points' and you can see the zero values at the bottom of the chart.
If I change the query to manually exclude data points that are null, the graph scales correctly. Is there anyway to get it to scale correctly when there are null values?
Here are some other screen shots:
{
"browser-info": {
"language": "en-US",
"platform": "Win64",
"userAgent": "Chrome/91.0.4472.164",
"vendor": "Google Inc."
},
"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.219-164.354.amzn2.x86_64",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"mysql",
"h2"
],
"hosting-env": "metabase cloud",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "mySql",
"version": "5.7.1"
},
"jdbc-driver": {
"name": "Connector/J",
"version": "unknown"
}
},
"run-mode": "prod",
"version": {
"date": "2021-06-15",
"tag": "v1.39.4",
"branch": "release-x.39.x",
"hash": "f538050"
},
"settings": {
"report-timezone": null
}
}
}
@grihol
Are you an Enterprise customer or using Metabase Cloud? Since there's off with your "Diagnostic Info".
I cannot reproduce
select -1 as "lag", 1 as "Jan_2021", 1 as "Feb_2021", null as "Mar_2021" union all
select 0, 1, 0.99, null union all
select 1, 1, 0.98, null
I'm using Metabase Cloud. Can you reproduce the issue with this code:
select -1 as "lag", 1 as "Jan_2021", 1 as "Feb_2021", 0.98 as "Mar_2021" , 0.98 as "Apr_2021" , 0.98 as "May_2021" , 0.98 as "Jun_2021" , 0.98 as "Jul_2021"
union all
select 0, 1, 0.99, 0.99,0.99,0.98,0.97,0.95
union all
select 1, 1, 0.99, 0.99,0.99,0.98,0.97, null
union all
select 2, 1, 0.99, 0.99,0.99,0.98, null, null
union all
select 3, 1, 0.99, 0.99,0.99,null, null, null
union all
select 4, 1, 0.99, 0.99,null,null, null, null
@grihol Have you modified the "Diagnostic Info" before posting it?
I've created an issue for the wrong data point:
https://github.com/metabase/metabase/issues/17205 - upvote by clicking 
on the first post
Yes, I don't think I have direct access to that information. A friend of mine helped me out.
@grihol Okay, then please either note that in the future, or just say you don't have access. I spend 20min chasing down what the problem could be with your "Diagnostic Info", since that was wrong on several levels and you said you were using our Cloud.