QUESTION: bar chart/order of week days mixed up

[Sabine]

Hi guys,

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?

Thanks a lot,
Reg. Sabine

[ScottWorld]

My guess is that the only way to accomplish this would be to create a formula which puts the day number in front of the name.

[Sabine]

Oha…
What is the criteria Airtable is ordering week days?

[kuovonne]

Sabine:

What is the criteria Airtable is ordering week days?

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.

[ScottWorld]

You may not even need to create a formula, if that is just some sort of a text field where you typed or selected the weekdays. If so, you can just add a number before the weekdays, if you want.

[Bill_French]

kuovonne:

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.

Complete insanity. This is why successful chart platforms abstract labels and other visual elements from IDs.

Airtable should spend all of its charting budget on clean and code-free integrations to Charts.js, D3 and Vega and stop the madness.

[MEO]

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.

[Sabine · Accepted solution]

Here we go, if we format the Weekday that way, the chart also works well: