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

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