Represents a filter which can filter data based on whether the data is below or above the average of the entire data range.
Constructors
Section titled "Constructors"AverageFilter
new AverageFilter(a: number, b: IFilterable, c: AverageFilterType): AverageFilterReturns AverageFilter
Properties
Section titled "Properties"$t: TypeAccessors
Section titled "Accessors"average
Section titled "average"Gets the average that was computed the last time the filter was applied or 0 if any errors or all non-numeric values were found when applying the filter.
get average(): number
Returns number
Gets or sets the value indicating whether to filter in values below or above the average of the data range. AboveAverage to show cells above the average of the data range; BelowAverage to show cells below the average.
get type(): AverageFilterType
Returns AverageFilterType