[Solved] Custom Expressions missing

glima · September 10, 2019, 1:57pm

Hi,

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?

Regards

flamber · September 10, 2019, 3:49pm

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

glima · September 10, 2019, 4:11pm

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.

flamber · September 10, 2019, 5:31pm

@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.

glima · September 10, 2019, 6:04pm

Thanks !

bmcgonag · June 30, 2021, 9:54pm

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.

flamber · July 1, 2021, 8:33am

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