Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: QUESTION: bar chart/order of week days mixed up

Solved
Jump to Solution
2048 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Sabine
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Bildschirmfoto 2022-02-06 um 17.02.02
Bildschirmfoto 2022-02-06 um 17.03.06

1 Solution

Accepted Solutions
Sabine
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Bildschirmfoto 2022-02-12 um 20.19.42

See Solution in Thread

7 Replies 7

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
5 - Automation Enthusiast
5 - Automation Enthusiast

Oha…
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.

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.

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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

Bildschirmfoto 2022-02-12 um 20.19.42