The Sort rows step sorts the entire table in ascending or descending order based on values in the column(s) you choose.
The example data we'll connect to this step has a table of 50 webinar registrants.
Let's say we're wanting to view this data with the top being the newest registrants by registration time. We can do this by setting a sorting rule where the values in the column "Registration time" are sorted in DESC (descending) order.
When you connect data to a Sort rows step, you'll first select a column with the values you're wanting to sort the data by.
You can then choose whether it should be sorted in ASC (ascending) or DESC (descending) order.
If you'd like Parabola to ignore blank values during sorting, you can check the box to "Ignore Blanks". Without checking this box, blank values will be considered the lowest value. Checking this box may be useful when sorting your data in ascending order.
If you require multiple sorting rules, click on the Add Sorting Rule link to add multiple rules in. The rules are applied top-down, so the first rule will be the first sort, and the second rule will sort entries within each group that has identical values in the column used in the first sort.
In the example below, we're first sorting by "Registration time" in descending order so we can quickly see the most recent registrants at the top. Then, we sort by "Webinar ID" in ascending order. We'll see that for rows where "Registration time" is 2020-09, the "Webinar ID" are properly sorted in ascending order.
- A key concept to remember when sorting data in Parabola is that you are sorting rows, and not cells.
- Ambiguous dates (such as MM/YYYY) are difficult to sort. Try using a Format Dates step to convert your dates into a less ambiguous format before sorting.