Help

Launched: sort options for chart and pivot table blocks

cancel
Showing results for 
Search instead for 
Did you mean: 
Katherine_Duh
Airtable Alumni (Retired)

Hi! Just want to announce some quick updates to chart and pivot table blocks.

Chart

You can now adjust the sort order of the items on the X axis of bar, line, and scatter charts.
x-bar-chart-sort-2
Here are the new sort orders that are potentially available.

  • View: order in view
  • X value: X-axis value (numeric value for number types, alphabetical for text values, the order of select options for select fields)
  • Y value: Y-axis value (ie count, summary value, etc.)

Pivot

You can now adjust the sort order of the rows and columns of your pivot tables.
pivot-table-sort-rows
Here are the new sort orders that are available:

  • Group: the values in the field (numeric value for number types, alphabetical for text values, order of select options for select fields)
  • Value: row/column summary value (i.e. count, aggregate value, etc.)
2 Comments
Alex_Armstrong
5 - Automation Enthusiast
5 - Automation Enthusiast

It would be great if we could adjust the size of the columns in Pivot tables for when we have items with more letters than typical farm produce :grinning_face_with_big_eyes:

erika_madeyou
4 - Data Explorer
4 - Data Explorer

Is this Sort by View feature not available on the free plan?