Feb 07, 2022 08:19 AM
I’m facing a problem in some of my interfaces where the value’s are not appearing in the right order whether I change it from Ascending to Descending.
For example. I have a bar chart as below where all the weeks are in the wrong order:
I’m pulling the 'Week’s from a table as follows. Weeks are a linked record.
Can someone explain what I’m doing wrong here?
Mar 02, 2022 08:27 AM
Did you get this figured out? We’re having the same issue
Apr 21, 2022 09:29 AM
Bump. Also having this issue
May 27, 2022 01:02 PM
Similar problem here. I need the ability to sort a line chart by a non numeric field.
May 27, 2022 05:23 PM
There are several different ways to set the sort order.
Oct 26, 2022 07:21 PM
Can I confirm that this sorting cannot be done within the interface? That the x-axis choice must be one of these that you listed for the interface to not automatically revert to Alphabetical? My X-Axis is a column with month and year (AUG-22) which cannot unfortunately be sorted as a date (it’s text) without adding in an irrelevant and confusing day.
Nov 22, 2022 12:55 PM
Add a date field to your data. Pick the end of the month. You can then hide that field. Now, in the interface use the Date field as your X-Axis and change the “Bucket by” to Month. That’s how I did it for your use case.