Hi there! Is there a way to make MySQL accept tinyint(1) MySQL datatype as a Number, and allow formatting?
I have a field called “order_success”, and another “new_contact”. Both have only 0 and 1 as values. I definded both of them as “Quantity” fields in metabase table metadata, but, since “new_contact” is defined as int(11) (ie, a normal integer field, allowing any integer), whereas “order_success” is defined tinyint(1) (this is a very small integer, allowing only 0 or 1 values), the former can be formatted as number, but not the later. Is there any workaround?