summarizeFunction property

String? summarizeFunction
getter/setter pair

A function to summarize the value.

If formula is set, the only supported values are SUM and CUSTOM. If sourceColumnOffset is set, then CUSTOM is not supported. Possible string values are:

  • "PIVOT_STANDARD_VALUE_FUNCTION_UNSPECIFIED" : The default, do not use.
  • "SUM" : Corresponds to the SUM function.
  • "COUNTA" : Corresponds to the COUNTA function.
  • "COUNT" : Corresponds to the COUNT function.
  • "COUNTUNIQUE" : Corresponds to the COUNTUNIQUE function.
  • "AVERAGE" : Corresponds to the AVERAGE function.
  • "MAX" : Corresponds to the MAX function.
  • "MIN" : Corresponds to the MIN function.
  • "MEDIAN" : Corresponds to the MEDIAN function.
  • "PRODUCT" : Corresponds to the PRODUCT function.
  • "STDEV" : Corresponds to the STDEV function.
  • "STDEVP" : Corresponds to the STDEVP function.
  • "VAR" : Corresponds to the VAR function.
  • "VARP" : Corresponds to the VARP function.
  • "CUSTOM" : Indicates the formula should be used as-is. Only valid if PivotValue.formula was set.
  • "NONE" : Indicates that the value is already summarized, and the summarization function is not explicitly specified. Used for Looker data source pivot tables where the value is already summarized.

Implementation

core.String? summarizeFunction;