Help

Re: Interface Designer Charts - Sort X Axis by Single Select Order

2589 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Street_ops
6 - Interface Innovator
6 - Interface Innovator

Hey Airtable Peeps!

I’m about a month into the process of migrating most of my company’s core google sheet docs into Airtable, and we’re all loving it! Many things for such an awesome product.

I’m building out some Interface Designer dashboards for my boss to get a high-level view of operations, and ran into a snag. In the sidebar apps on the table it defaults to sorting single-select fields by their user order, which is the behavior that I want. This is what it looks like:
Screen Shot 2022-05-06 at 6.28.57 PM

But on my interface, I created a bar chart that shows each record filtered by a single-select column, but my only sort options are ascending/descending alphabetical.
Screen Shot 2022-05-06 at 6.41.59 PM

So this is a two-part question:

  1. Feature Request: The option to sort charts driven by single-select fields by user order.
  2. Workaround: In leu of that, how would you recommend I sort this (without just adding a number to the names, that would break several other formulas).

Thanks!
Paul

11 Replies 11
Street_ops
6 - Interface Innovator
6 - Interface Innovator

100% Unhelpful, self indulgent bump comment. :winking_face:

Josh_Himwich
4 - Data Explorer
4 - Data Explorer

Agree 100% - Interface is a great concept and it’s so close to being production-ready. That it sorts the data alphabetically rather than how it’s ordered in the table seems like a strange oversight and hopefully it’s at the top of the list of items to be fixed. Once it is, we can go live with Interface with some of our clients and internal partners.

benhamilton
4 - Data Explorer
4 - Data Explorer

This is really needed!  We are trying to build pipeline views and there is no way to just show them based on the status order, I'm having to make a giant switch formula to show status as a number so we can sort them which is a pain! 

ruihanzhao
Airtable Employee
Airtable Employee

Hi! We just added the ability to sort based on select choice ordering to bar charts in interface designer! Now in addition to "Ascending" and "Descending", there should be a "Select choices" option. Let us know if that helps simplify some of your workflows!

Screenshot 2023-06-09 at 11.50.19 AM.png

@ruihanzhao - I'm sure it's straight forward, but is there any documentation on how this is supposed to work?  I don't see any change when I set the sort to "Select choices".

ruihanzhao
Airtable Employee
Airtable Employee

@fred_b If you select "Select choices", the X-axis values should now be in the order in which the select choices were added. For example, here the X-axis would be ordered" "Improvement", "Needs QA", "Design", then "Engineering"Screenshot 2023-06-22 at 5.25.52 PM.png

Thanks!   Works perfectly.

maliyassi
4 - Data Explorer
4 - Data Explorer

Hi @ruihanzhao , I can't use "Select choices" if the main field is "Name" or "Number" etc. It's just working with Status I think. Could you please help me with this?

ruihanzhao
Airtable Employee
Airtable Employee

Hi @maliyassi "Select choices" are only available for "Single select" fields and lookup of "Single select" fields as that sort is based on the order of the select choices entered during the field configuration

Thanks for this insight. So, is it possible to rearrange your select options under 'customize field' and have the order represented, or do you have to input the select options in the correct order the first time?

ruihanzhao
Airtable Employee
Airtable Employee

@Frank_Gannon1 You can rearrange the select options (there should be drag handles) and the ordering should be reflected!