Sort Transform

Use sort to order your results by any column.

Basic Syntax

$ Basic Syntax
$ ctrl+enter to run

Sorting is ascending by default.

Descending Order

Prefix a column with - to sort descending:

$ Descending Order
$ ctrl+enter to run

Multiple Columns

Pass multiple columns to break ties:

$ Multiple Columns
$ ctrl+enter to run

This sorts by total descending first, then by created_at ascending for ties.

Combined with Take

Combine sort with taketo get the top N results:

$ Combined with Take
$ ctrl+enter to run