How to enable custom remapping in a field?

lfcipriani · September 28, 2017, 2:10pm

Hello,

I’m using Metabase 0.25.2 and I’m trying to enable custom remapping but the option simply never appear. Given a numeric field I have (Postgresql integer field) I tried to:

set as Category
set as number
set as no special category

None of these cases the custom remapping option appeared on Display Values. The doc doesn’t mention how to use them as well.

Thanks

lfcipriani · September 28, 2017, 2:27pm

So, I think I found the issue. I was trying to add custom remapping for a PostgreSQL View and the option never appear on Display Values menu. However, if I try to do the same with a table, it works no matter the type I select.

In summary, if you’re using Postgresql views, you cannot rely on custom remapping.

Reported here: https://github.com/metabase/metabase/issues/6065

jinchener · May 10, 2018, 6:36am

just support original numeric fields？
not supper for the text type？

jornh · May 10, 2018, 8:17am

Yes correct, that’s currently a limitation, see:

deanputney · June 28, 2018, 5:24pm

I’m having a very similar problem, but with a MySQL database. This table is not a view. Same scenario: I can set the type to any numerical type (the original type is type/Integer) and still not receive the option to do a custom mapping. Why is this?

fvafva · March 12, 2019, 2:05pm

I have the same issue with mysql.
In my table I have different fields, some of them have the option to do a custom mapping, some of them not.
From mysql it is a type/Integer. And the conf in metabase is exactly the same for both fields.

flamber · March 12, 2019, 4:32pm

Hi @fvafva
There’s an issue, when there are NULL values - go and upvote by clicking

fvafva · March 13, 2019, 9:05am

Many thanks for your answer, I missed that info in github.

brianwilson · June 24, 2021, 4:07pm

Im using Ver 39.1 - source database is Sqlite. Column has no null values (varchar) but is nullable. I dont seem to be able to get the custom mapping option to display

flamber · June 25, 2021, 9:47am

@brianwilson Metabase does currently not support mapping of strings:
https://github.com/metabase/metabase/issues/11445 - upvote by clicking on the first post

janpeterka · October 19, 2023, 11:16am

I'm unable to set custom mapping on Metabase 0.47.4, MySQL.

I'm trying to set column type to all Numerical types:

Quantity
Score
Share

Also not working on Category, where it worked in past (I have other table and column with Category type where mapping is present)

Not sure how to get custom mapping working..

Luiggi · October 20, 2023, 1:18am

running 47.4

you should check that the field base type is type/integer