Use the"sort" directive to order rows of data by values in selected columns.
For instance, to sort the "Customer" worksheet rows by "Last name" descending with ties broken by "First name" ascending, place the following directive in a comment in the "OrderedByLastName" worksheet.
pebblestream:from(Customer) pebblestream:sort("Last name":desc, "First name":asc, ...)
'Sort' can now be used with 'group' directive!
This will be the worksheet you'll be sorting.
Step 4: Select the column(s) you'd like to sort & what you'd like to sort them by (ascending or descending order)
You can sort as many columns as you'd like by clicking the '+' button to add more sorts.
This will be where your output data from adding 'sort' will be.
Your spreadsheet will automatically take you to the output worksheet. See the results of grouping the data in your worksheet!
For more technical and in-depth information on our 'sort' directive, do visit our Pebble Stream Enterprise Documentation
Updated 7 months ago