Summarizing custom question behavior


I'm new to Metabase and after days trying, I'm in love with this tool and proposing to use this tool for management in the company I'm working at.

I found something that doesn't work normal.
Ask a question -> Custom question -> Saved Questions
I pick my metric column and then I pick a date column.

The result is all columns are showing. (Sorry can't upload more than 3 images)

But when I create my metric using a formula and pick the same date column.

The result is correct

Is there any step that I miss to produce the second result using the first way?
Thank you!

Hi @abed
Please post "Diagnostic Info" from Admin > Troubleshooting.
It sounds like you're seeing this issue, but it's difficult to say for sure without more details

Hi @flamber
Please find the 'Diagnostic Info" below

  "browser-info": {
    "language": "en-US",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/90.0.4430.93 Safari/537.36",
    "vendor": "Google Inc."
  "system-info": {
    "file.encoding": "UTF-8",
    "": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.10+9",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "",
    "java.version": "11.0.10",
    "": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.10+9",
    "": "Linux",
    "os.version": "5.4.0-1029-aws",
    "user.language": "en",
    "user.timezone": "GMT"
  "metabase-info": {
    "databases": [
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "13.2 (Debian 13.2-1.pgdg100+1)"
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.18"
    "run-mode": "prod",
    "version": {
      "date": "2021-04-20",
      "tag": "v0.39.0.1",
      "branch": "release-x.39.x",
      "hash": "47bb5f2"
    "settings": {
      "report-timezone": "Asia/Jakarta"

Apologies for not being clear, I was in a hurry when making this post.
I was actually trying to create a pivot from Custom Question. However, in the process, I experienced something that I think is not normal.

At this stage, I picked membership_fee from the question that I created and I picked created_at (month) to group by. So, normally (correct me if I'm wrong), the result - when I clicked visualize - would be only 2 columns which were the sum of membership_fee and month. However, the result was different from what it should be. It returned all the columns from the question I created.

Then I tried another experiment. Instead of picking up the membership_fee, I created a formula, sum(membership_fee), with the same field to group by. When it's done this way, it resulted correctly.

@abed Check your browser developer console, when creating the question, where it's not creating the a result with just two columns even though you have selected it.
If you're seeing the error Removing invalid MBQL clause, then it's issue 15725

Yes, you are correct. I can see an error Removing invalid MBQL clause.
Alright then, need to do the workaround about this.
Thank you @flamber!