Error on use summarized column on custom column

Hi!

I think it’s a bug, when I created a summarized column called anoa and anob, and then I wanna create another collumn, custom, using anoa and anob.
When I try, this columns its showerd as a sugestion, but if I try use it, I get an error

I just tried do anoa + anob, but I got ther ‘column source.anoa does not exist’

{
“browser-info”: {
“language”: “pt-BR”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:77.0) Gecko/20100101 Firefox/77.0”,
“vendor”: “”
},
“system-info”: {
“file.encoding”: “UTF-8”,
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “11.0.7+10”,
“java.vendor”: “AdoptOpenJDK”,
“java.vendor.url”: “https://adoptopenjdk.net/”,
“java.version”: “11.0.7”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “11.0.7+10”,
“os.name”: “Linux”,
“os.version”: “4.14.173-137.229.amzn2.x86_64”,
“user.language”: “en”,
“user.timezone”: “America/Sao_Paulo”
},
“metabase-info”: {
“databases”: [
“mongo”,
“googleanalytics”,
“mysql”,
“postgres”,
“h2”
],
“hosting-env”: “unknown”,
“application-database”: “postgres”,
“application-database-details”: {
“database”: {
“name”: “PostgreSQL”,
“version”: “9.6.11”
},
“jdbc-driver”: {
“name”: “PostgreSQL JDBC Driver”,
“version”: “42.2.8”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-05-28”,
“tag”: “v0.35.4”,
“branch”: “release-0.35.x”,
“hash”: “b3080fa”
},
“settings”: {
“report-timezone”: “UTC”
}
}
}

I Think this is the problem, the alias for that sum should be anoa and anob, no sum-where and sum-where2, or at least renamed on the select

For now, I will use this sql, but fixed xD.

actualy, this query its very very wrong. The first subquery Is tryng get some columns that is not on the select on the third subquery :thinking:

I think this stuff its resolved before this query genered for us

Hi @geovani

Would it be similar to this in Sample Dataset?

I have a feeling that it’s very related to this issue:
https://github.com/metabase/metabase/issues/12507

1 Like

yep! ty

@geovani I’ve created a separate issue you can track even though I think it’s a duplicate:
https://github.com/metabase/metabase/issues/12762 - upvote by clicking :+1: on the first post

1 Like