The options for changing the order of rows in a Table differs depending on the Visualization and Metric you're using.
HOW TO
How to change the Sort Order in a Table
Pro Tip: This is the strategy for changing the order of rows in Advanced Tables, Leaderboards, or Tables with Data from: Single Metric selected.
- In the Designer, click on the Advanced Table, Leaderboard, or Table Datablock where you want to change the Sort Order. This will open Datablock Settings on the righthand side
- At the bottom of Datablock Settings you can select the Sort by field and the Sort Order.
The Sort by field determines the defining factor for sorting the rows of your Table, while the Sort Order gives you the opportunity to display either the highest or lowest values first. Value is the default Sort by selection and Descending is the default Sort Order selection, so rows are automatically sorted from highest to lowest values.
Selecting Name as the Sort by option will sort the rows in alphabetical order, Change will sort the rows based on the percent change value, and Date will sort the rows based on the date the most recent data was returned.
Selecting Descending as the Sort Order will sort and display rows from starting with the lowest value.
Pro Tip: Enter the number of rows you want to be displayed in the Limit rows field. This is valuable to display "Top 15 Performing Blog Posts" or "Top 10 Pages by Time on Page."
How to move rows in a Table
Pro Tip: This is the strategy for changing the order of rows in Tables with Data from: Multiple Metrics selected.
-
In the Designer, click on the Table Datablock where you want to move the rows. This will open Datablock Settings on the righthand side
-
Each Metric is manually added to the Table and is displayed in Datablock Settings. Click on the row icon to the right of the Datablock name and drag and drop it to the desired location on the Table