Feb 06, 2022 08:06 AM
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
Solved! Go to Solution.
Feb 12, 2022 11:21 AM
Feb 06, 2022 10:00 AM
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.
Feb 06, 2022 11:42 AM
Oha…
What is the criteria Airtable is ordering week days?
Feb 06, 2022 12:27 PM
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.
Feb 06, 2022 12:29 PM
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.
Feb 07, 2022 01:22 PM
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.
Feb 09, 2022 11:00 AM
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.
Feb 12, 2022 11:21 AM
Here we go, if we format the Weekday that way, the chart also works well: