The Cell Summary Function allows you to see - at a glance - summary information about the cells (and rows) you have selected in AdapTable.
Simply select a group of cells and you can see the summary information about those cells in the Cell Summary Toolbar and / or Tool Panel
AdapTable ships with a large set of common Summary Operations.
If you have installed the Finance Plugin then extra finance-related Operations are available.
You can provide your own Summary Operations in Cell Summary Predefined Config
AdapTable Cell Summary Operations
The following Cell Summary Operations are shipped with AdapTable:
|Sum||Numeric||Total of all selected cells|
|Average||Numeric||Average of all selected cells|
|Median||Numeric||Middle (value) of all selected cells (when ordered)|
|Mode||Numeric||Most common value|
|Distinct||All||Count of distinct selected cell values|
|Max||Numeric||Highest selected Cell Value|
|Min||Numeric||Lowest selected Cell Value|
|Count||All||Number of selected cells|
If using the Finance Plugin the additional Cell Summary Operations are available:
|Only||Numeric||Returns true if all selected cells match (single column only)|
|VWap||Numeric||Runs VWAP analysis - requires selection of 2 contiguous columns|
|WeightedAverage||Numeric||Calculateds the Weighted Average - requires selection of 2 contiguous columns|
Custom Cell Summary Definitions
Developers can add their own Cell Summary Definitions at design-time.
Provide a custom, named
CellSummaryOperationFunctionimplementation in the User Functions section of Adaptable Options.
Reference that function by name in the Cell Summary section of Predefined Config.
Cell Summary includes the following UI Elements:
Popup - Shows all the Cell Summary Operation results for the selected cells
Toolbar - Displays the result of the curently selected Cell Summary Operation (available through a dropdown). Choose a different item in the dropdown to see a different operation, or click on the 'info' button to see all the Operations.
Tool Panel - Same as Toolbar above.
Context Menu -
See Cell SummaryMenu Item opens Cell Summary popup (only visible if selected cells are editable).
Cell Summary Entitlement Rules:
Full: All Cell Summary Operations will be displayed (and can be selected)
Hidden: All Cell Summaries are hidden from the User
Can we add our own Summary Operations?
Yes, you need to provide a
CellSummaryOperationDefinition in your Cell Summary Predefined Config.
Can we see Financial Operations?
Yes, if you use the AdapTable Finance Plugin