Sort | Weaverbird

User interface

General Principles Add Missing Dates Add text column Add Total Rows Aggregate Append Compare Text Columns Argmax Argmin Concatenate columns Convert Convert date to text Convert text to date Cumulated sum Custom step Delete column(s) Geographically dissolve data Duplicate Duration Evolution Extract date information Extract substring Fill null Filter Formula Geographical hierarchy Get unique groups/values Hierarchical rollup ifthenelse Join Keep column(s) Moving Average Percentage Pivot Rank Rename Replace Geographical simplification Sort Split column Column's Statistics To lowercase To uppercase Top N rows Unpivot Waterfall

Technical documentation

Packages Steps Designing a new step Known limitations Variables UI components Custom code editor Python package

Sort values

You can use this step to sort values based on one or several columns.

This step is supported by the following backends:

Mongo 5.0
Mongo 4.2
Mongo 4.0
Mongo 3.6

Where to find this step?

Column header menu
Search bar

Options reference

Column...: the column where values will be sorted
Order: whether you want the values in this column to be sorted in ascending (asc) or descending order (desc).

You can add columns to apply a combined sort, by clicking on “Add column”. The order of columns matters, i.e. first the first column will be sorted, then and without changing the order of the first column, the second column will be sorted etc. Please see the example below for illustration.

You can specify if you want to rank rows based on one or several columns.

Example

This configuration results in:

First the column country is sorted by ascending order, and then values are sorted by descending order.