How to sort Categories in table and charts?


#1

I need a way to be able to sort categories in specific order
Currently, I am only able to sort alphabetically or numerically using Metabase standard query builder.

The categories are Revenue, Direct Cost, Manpower, Supplies & Materials, Incidental and Depreciation, in that order.
I’ve tried creating the field type as enum in the database (Postgres), but ran into different problem as Metabase does not recognize the custom data type.

Thanks.


#2

You could use the SQL builder and add an order by category = ‘Revenue’, category = ‘Direct Cost’, category = ‘Manpower’, etc… to the query.