Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Visual Analytics sorts the innermost dimension records by their measure value. This creates a manual sort for the innermost dimension. The following example shows Territory sorted in the ascending order by profits of Bike Racks. See Also, Manual Sorting.

  • You can apply tooltip sorting on the leaf headers only when a dimension is present in the Chart Properties Deck. Visual Analytics sorts data of each cell by its measure values for that header record. The following example sorts individual chart segments of each cell by its measure values. 

...

You can sort data directly from the toolbar. The following table describes the scenarios in which the sort icons on the toolbar will be enabled.

ScenarioDescription
A single dimension in the table chartVisual Analytics sorts records by their count values.
One or more dimensions in the Chart Properties Deck for Pie, Sunburst, Mekko, Funnel and Bar charts.Visual Analytics sorts by per cell by measure values.
A single dimension and one or multiple measures in the chart
  • With a single measure: Visual Analytics sorts data based on its values.
  • With multiple measures: Visual Analytics sorts data based on the outermost measure in the Rows Deck.
  • With multiple measures where a measure is selected: Visual Analytics sorts data based on the selected measure values.

The following example shows product categories sorted on profit values because the selected measure is profit.

...