About Sorting Data in Visualizations

In Oracle Analytics, you can optimize the usefulness of a visualization and improve its readability by sorting the data.

The following options are available to sort by:
  • Attributes - Alphabetically A to Z or in reverse alphabetical order Z to A.
  • Measures - In ascending order Low to High or descending order High to Low based on value. Measure sorts take precedence over attributes and dates.
  • Dates - In chronological order Earliest to Latest or reverse chronological order Latest to Earliest.
  • Attributes based on measures - In ascending order Low to High By or descending order High to Low By. You can also use a measure that isn’t used in the visualization.

You can sort the data in a visualization by an individual attribute or measure, or you can define a sort order to apply multiple sorts to the visualization.

If you have any sorts applied to a visualization in Edit Mode and you save the workbook, those sorts are included. To clear all existing sorts, you can right-click the visualization, hover over Sort By, and click Clear Sorts.

For information about sorting in tables and pivots, see About Tables and Pivots.

To control which sort options are available to consumers, see Specify the Workbook Visualization Actions in Present.

You can’t sort data in the following visualization types:
  • Network
  • Dashboard controls
  • Language Narrative
  • Map
  • Timeline
  • Text
  • Image