Drill-through in Custom Questions with Custom Columns

Get Help
1

Hi!

I'm sharing with you a problem that we currently have in my company.
The drill-through feature is not working in Custom Questions that have Custom Columns created from aggregated values.

Just in case it's helpful to understand, these are the steps:

  1. Create the Custom Question with aggregated values.

    13
    131616Ă—640 28 KB

    The drill-through feature works up to here.

  2. Create the Custom Columns using those aggregated values:

    45
    451612Ă—972 68 KB

    The drill-through feature is not available in the output:

  • In a table: the figures are not clickable.
  • In a line or bar chart: the dots are clickable but when the menu is displayed, the option "View these..." seems to be clickable but nothing happens when clicking.
    56

We are in love with the drill-through feature, but it would be critical for us to make it work in this cases too.

Thanks in advance for the support and all your work!

2

Hi @fervillarce
Please post “Diagnostic Info” from Admin > Troubleshooting.

3

Hi @flamber!

Thanks for your quick reply, here is the Diagnostic Info:

{
  "browser-info": {
    "language": "en-GB",
    "platform": "MacIntel",
    "userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.135 Safari/537.36",
    "vendor": "Google Inc."
  },
  "system-info": {
    "file.encoding": "UTF-8",
    "java.runtime.name": "OpenJDK Runtime Environment",
    "java.runtime.version": "11.0.5+10",
    "java.vendor": "AdoptOpenJDK",
    "java.vendor.url": "https://adoptopenjdk.net/",
    "java.version": "11.0.5",
    "java.vm.name": "OpenJDK 64-Bit Server VM",
    "java.vm.version": "11.0.5+10",
    "os.name": "Linux",
    "os.version": "4.14.193-149.317.amzn2.x86_64",
    "user.language": "en",
    "user.timezone": "UTC"
  },
  "metabase-info": {
    "databases": [
      "postgres",
      "redshift-spectrum"
    ],
    "hosting-env": "unknown",
    "application-database": "postgres",
    "application-database-details": {
      "database": {
        "name": "PostgreSQL",
        "version": "11.4"
      },
      "jdbc-driver": {
        "name": "PostgreSQL JDBC Driver",
        "version": "42.2.8"
      }
    },
    "run-mode": "prod",
    "version": {
      "date": "2020-04-21",
      "tag": "v0.35.3",
      "branch": "release-0.35.x",
      "hash": "1d424cb"
    },
    "settings": {
      "report-timezone": null
    }
  }
}
4

@fervillarce Currently there’s a bug, which means Custom Column doesn’t work on aggregated data:
https://github.com/metabase/metabase/issues/12762 - upvote by clicking :+1: on the first post

1 Like
5

Actually we are running in the previous version because of that bug, that we already upvoted it :slight_smile:
Ours would be affected by that one (in the last version), because it has to do with Custom Columns in Custom Questions. Anyway, hope it is solved along with the blocker you indicated.
Many thanks!

6

Hi! Running v0.41.4 and we're unable to drill down on custom columns. Is this expected? Same behaviour as above, the "View these..." is clickable but no action.

7

@flamber :slight_smile:

8

@michaela.klassen

Try upgrading to a newer release: https://github.com/metabase/metabase/releases

And I cannot reproduce, so please include steps-to-reproduce.

9

Thanks for the reply :slight_smile: I updated and the issues persists. If I create any custom column, for example I simply multiplied a count of rows by 100, I am not able to drill down. The "view these accounts" button appears on hover, but there is no action on click. It also appears as though I can't drill down on any of the other columns, so long as a custom column exits. When I remove the custom column, I can drill down again.

04%20PM

32%20PM
32%20PM665Ă—682 28 KB

10

@michaela.klassen Correct, because it creates a nested query. Use Custom Expression instead.