Interface Chart Value's are Displaying in Wrong Order

Hi there.

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?


Hey Dan,

Did you get this figured out? We’re having the same issue

Bump. Also having this issue

Similar problem here. I need the ability to sort a line chart by a non numeric field.

There are several different ways to set the sort order.

  • Alphabetical sort (This is what happens when none of the other situations apply.)
  • Numeric sort (This requires a number field, not a text string that looks like a number.)
  • Date sort (This requires the field be a date field, not just text string that looks like a date to a human.)
  • Select choice sort (The order of select choice as defined when configuring the field. This requires that the value be a select field.)