Enumeration: SlicerAggregateType

Spread.Slicers.SlicerAggregateType

Represents the aggregate type.

Table of contents

Enumeration members

• average
• count
• counta
• max
• min
• product
• stdev
• stdevp
• sum
• varp
• vars

Enumeration members

average

• average = 1

Calculates the average of the specified numeric values.

count

• count = 2

Calculates the number of data that contain numbers.

counta

• counta = 3

Calculates the number of data that contain non-null values.

max

• max = 4

Calculates the maximum value, the greatest value, of all the values.

min

• min = 5

Calculates the minimum value, the least value, of all the values.

product

• product = 6

Multiplies all the arguments and returns the product.

stdev

• stdev = 7

Calculates the standard deviation based on a sample.

stdevp

• stdevp = 8

Calculates the standard deviation of a population based on the entire population using the numbers in a column of a list or database that match the specified conditions.

sum

• sum = 9

Calculates the sum of the specified numeric values.

varp

• varp = 11

Calculates the variance based on a sample of a population, which includes numeric, logical, or text values.

vars

• vars = 10

Calculates the variance based on a sample of a population, which uses only numeric values.