Support Advance Sort with Grand Total Column in Cross Table
Refer Advance
Sort for configuring sorting on the widgets.
Cross Table has additional configuration in Advance Sort, to add sorting
condition based on the Column Grand Total.
To understand the configurations, follow the below steps:
1. Plot cross table,
ex. Below configuration
The plotted chart shows data as below:
2. Navigate to
Advance Sort options. The additional option is displayed with name- Add Column
Grand Total.
3. On click of -Add
Column Grand Total, the sorting level is added.
4. On click of Select
Column dropdown, the column/s configured in the Value configuration are
displayed. Select any column.
5. Set the sorting
level as Descending or Ascending.
6. Click Apply.
7. Observe the chart
data. Data in the Column Grand Total Column (Births-Sum) is displayed sorted in
Descending order considering entire row values.
|
Notes: |
o The sorting levels can be added on any number of columns in the value configuration with different sorting. o The sorting on -Column Grand total Column can be combined with the sorting on other dimension columns in the configuration. |
Related Articles
Grand Total
The Grand Total formatting option is available in the Cross Table widget. By default, the Grand Total formatting options are not visible. Turn the toggle button ON () to use the Grand Total formatting options. The table given below describes ...Total
The Total formatting option is available in the Table chart. The table given below describes different fields present on Total formatting. Field Description Remark Label It allows you to select the label you want to assign for the Total column. — ...Total And Sub-Totals
No table of figures entries was found.h1. Formatting a Table You can format the tables that appear in various charts. Tables can be plotted standalone like Table and Cross Table, or they accompany other charts (like Sparkline Chart in which they ...Sorting Data in Widgets
You can sort a widget based on the variables present in the chart. The default sorting of the chart is as per the data from the input dataset. For charts with legend, if you select a feature as a Legend, the numerical variable plotted on the Y-axis ...Support Vector Machine
Support Vector Machine is located under Textual Analysis ( ) in Classification, in the left task pane. Use the drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Refer to ...