You know it’s a typical scenario that uses SQL
case when syntax to map integer constant value to a literal text. For example, an Order table contains a column called status which possible integer values are
(1,2,3) and corresponding text are
However, I think it’s stupid if I should write such case when statement over and over. I hope Metabase have such a nice feature can support mapping constant field value automatically after a simple configuration in Data Modal.
I thought Data Modal -> Table -> FIELD SETTINGS -> Display values -> Custom mapping can achieve this, but not. It only applies to filter.