I never seem to see any useful fields to sort by in the question interface - e.g. I’ll have three fields in the view, but sort by will show none, or maybe only one of the fields. Any ideas? If I click on a column name and choose ascending / descending, there is an error and I have to start over w/ the question.
This is the error I get when clicking a column header and choosing ‘descending’ for example:
org.postgresql.util.PSQLException: ERROR: column “named” does not exist Position: 893
Which version of Metabase?
Are you using regular tables, Views, or?
Are you creating Custom Expressions or Custom Fields, and trying to order by those?
If you click the three-dots button (Additional Options) to the right, then you can create multiple sort by’s, whereas clicking the columns only sorts the selected column.
Additionally, if I click on the column named ‘Shipped Tons’ and then choose ‘Ascending’ or ‘Descending’ it actually no longer throws an error but just doesn’t work at all - it sorts by a different column entirely.