Hi, I'm trying to sort the data in my chart i...

(Sylvain Rossy) #1

Hi, I’m trying to sort the data in my chart in a way that the highest number is on the left and the smallest is on the right. The numbers shown here is a group agregate (SUM) of a column. How can I manage to have this working ? Thanks in advance, Sylvain

(Reza Raoofi) #2

You cannot sort columns in a column chart; AppSheet will automatically display columns by the order of values in key column.

One workaround would be to build your aggregate calculations in spreadsheet using things like Pivot Table and then sort results there and add a column with sequential values in the order you wish next to aggregate results, then add it to your app as read-only table and consider that additional column as Key in column structure. Basically hacking the result set that you want to build chart on.