Help

Launched: sort options for chart and pivot table blocks

cancel
Showing results for 
Search instead for 
Did you mean: 
Katherine_Duh
10 - Mercury
10 - Mercury

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?