[Solved] Custom Expressions missing


For some datasets the custom expression option on Custom Questions do not appear, do you know if my datamodel should follow some specific format so I can enable the custom expressions?


Hi @glima
Which version of Metabase?
Which database are you querying?
Are you sure it’s not just hiding below a scroll? Can you provide a screenshot - just to make sure we’re talking about the same thing :wink:

1 Like

Metabase v0.33.2

It isn’t hidden below.

This is what I can see using the sample dataset from metabase:

Here it goes my datamodel.

@glima Ahhh yes, it’s because you don’t have any number-types (decimal, float, integer) in the table (if you do, then set the Field Type of the column in the Data Model). That’s also the reason why you don’t have all the regular Basic Metrics.

1 Like

Thanks !

Hate to revive an older post, but is this solution still valid? I recently switched my data from mySQL to MongoDB, and although I have identified several fields as Currency and Number types, it doesn't give me the Custom Expression option.

I'm on Metabase version 0.39.4 from June 15, 2021.

@bmcgonag You are seeing this issue, which is specific to MongoDB:
https://github.com/metabase/metabase/issues/7097 - upvote by clicking :+1: on the first post