Source Data- Data Range to be filtered and/or summarized. Upon binding the Source Data, the Columns list box is populated with a list of each column.
Destination Range- Data range where the filtered and/or summarized data is inserted. The destination should contain the same number of columns as the source data. Upon binding data to the Source Data property, a list of columns will be populated within the Columns list box.
Enable Summary Calculations- Toggle for turning the summarization feature on or off. Summary calculations drive dynamic aggregation of Source Data before it is inserted into the Destination Range.
Aggregate Column Index- Entered as a single numeric value, the Aggregate Column property identifies the column for which the Source Data is aggregated by.
Column Name- Identify each column with a name to provide context for the dashboard developer.
Column Filter- Filter data from the source data range using Column Filter values. Each column is capable of containing one or multiple filters, resulting in tremendous control over what data is displayed in the Destination range.
Filter Type- Refine the filtering operation with “Equals” or “Contains” operations that provide standard filtering using column filter values.
Calculation Type- Select one of 4 calculation types to filtered data to enable dynamic summarization of data before it is inserted into the destination range.
List Destination- Destination range where distinct values within the Source Data column are inserted.
|
Filtered Summary is a transparent calculation component that can be injected into any Xcelsius® dashboard to dynamically summarize and filter data. Filtered Summary evaluates source data, applies filters and summarization calculations, and then inserts into a destination range.