Question based on another 2 questions in same dashboard

Get Help
1

I have 3 questions in my dashboard. The first 2 are how much product was produced and the second one is how much was expected. I want a 3rd metric, a new question, that takes those 2 results and divides them, to get the efficiency percentage.

image
image1690×473 32.6 KB

I am unable to reference the other 2 questions in a new question, as the columns are wrong:

image
image2433×1178 111 KB

The column appears as it having no name. In the SQL of that question, the column has the name of "sum", autogenerated by metabase itself.

I'm not sure how to get around this issue

2

{
"browser-info": {
"language": "pt-PT",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36 Edg/128.0.0.0",
"vendor": "Google Inc."
},
"metabase-info": {
"databases": [
"h2",
"sqlserver"
],
"run-mode": "prod",
"plan-alias": "",
"version": {
"date": "2024-08-26",
"tag": "v0.50.22",
"hash": "16a6c22"
},
"settings": {
"report-timezone": null
},
"hosting-env": "unknown",
"application-database": "h2",
"application-database-details": {
"database": {
"name": "H2",
"version": "2.1.214 (2022-06-13)"
},
"jdbc-driver": {
"name": "H2 JDBC Driver",
"version": "2.1.214 (2022-06-13)"
}
}
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "21.0.4+7-LTS",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "21.0.4",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "21.0.4+7-LTS",
"os.name": "Linux",
"os.version": "6.8.0-41-generic",
"user.language": "en",
"user.timezone": "Europe/Lisbon"
}
}

3

hey your use case is really good, can you tell us how the 2 previous metrics were created?