tried the interface designer the first time today. in one of our bar charts the order of the week days is mixed up (see below). There are only two options (ascending, descending) which doesn’t help us.
Any idea how we can set it up correctly?
The issue is that Airtable does not know that these are week days. The chart is sorting the labels alphanumerically. In order to get the sort you need to have the alphanumerically sort match the sort you want–hence converting the weekday to a number.
If you setup the Wochentag field in your table as a single-select, then you can order those single select options however you want by dragging them. That order would then become the “ascending” order in your bar chart.