Sorting Data
Sorting is a method of ordering data by ascending or descending by letter, number or date.
- Data is typically in natural order
- the order in which the data is entered.
- most common sort method is ascending and descending order
- for numerical data:
- ascending is the minimum number sorted to the top and the maximum number at the bottom
- for numerical data:
Advanced Sorting Methods
Multi-sorting is a method of sorting where you sort within a sort.
Top N and Bottom N sorts are sorts that display the top or bottom of the data in a set based on a number you specify, or N.
- e.g., want to view the top 25 most-ordered products
Custom sort is sorting when you create the data set to include the value and the sort order you need for your visualization.
- great for nominal data that does not have a sort
Sort Functions
- Rank and Order are sort related functions