Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam
Visual Analytics also allows clearing an applied sort and changing the default sorting properties for any dimension.
You can sort data by using sort icons present on the measure axis, column and row headers, toolbar and tooltip. You can also sort data by using the menu options for dimensions present in the chart properties deck.
You can sort data using the sort icons on measure axis. Hover, the mouse on a measure axis, to see the sort icon. When you click the icon once, data is sorted in the descending order, click again, and data is sorted in the ascending order. If you click again, the data is reset to its default order. The following example shows product categories in ascending order based on their profit values.
Hover the mouse on a column or row header, to see the sort icon. When you click the icon once, the cells of the selected row/column are sorted in the descending order, click again, and data is sorted in the ascending order. If you click again, the data is reset to its default order.
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.
|A single dimension in the table chart||Visual 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||
The following example shows product categories sorted on profit values because the selected measure is profit.
This option sorts data based on the aggregation values of the specified field. To apply sorting, from the Field drop-down list, choose a dimension or measure, and then from the adjacent drop-down list, choose an aggregation function. The following example shows product categories based on profits but sorted according to the average value of the tax amount.
Manual sorting lets you control the order in which data appears in the chart view. You can move the records up and down the list and also reverse the order of the list by using the scroll arrows.
Clear Sort removes sorting from the chart view. The chart view is reset to the default sorting properties of the dimension. To remove sorting, in the chart view > right-click the dimension > Sort > Clear Sort.