Sorting data in Visualizer

Sort data in a report using Sort in the Chart Builder. Measures can sort in ascending or descending order. Attributes sort alphabetically or reverse-alphabetically. If you sort by a time or date attribute such as by Day or Month, the report is automatically sorted based on the sequential order of the date value and not based on the alphabetical sort.

To change the way data is sorted:

  1. Add the desired attributes and measures to create your chart. For example, Units in Stock by Country.
  2. To sort data, drag a column in the Chart Builder and drop it on Sort. For example, to sort by UnitsInStock, drag UnitsInStock from Measures to Sort.
    Caution: 
    Sorts do not take effect by dragging a column from the Subject Area to Sort. You must use a column that is already in the Chart Builder. To hide a column see Adding Tooltips and Hiding Columns.
  3. Visualizer sorts the measure or category (attribute) according to its default sort criteria. For example, UnitsInStock sorts from lowest to highest. If you sort by Day or date, the report is automatically sorted based on the sequential order of the date value and not based on the alphabetical sort.
  4. You can change the type of sort to apply. Visualizer provides sort options in the Subject Area.
  5. You can add additional columns to Sort.
    Note: When sorting on two measures where one is an expression, the sort on the expression takes precedence. This is because expressions are sorted at mid-tier whereas basic columns are sorted at the database level.
  6. Click Save.