View Source GoogleApi.Sheets.V4.Model.PivotFilterCriteria (google_api_sheets v0.34.0)

Criteria for showing/hiding rows in a pivot table.

Attributes

  • condition (type: GoogleApi.Sheets.V4.Model.BooleanCondition.t, default: nil) - A condition that must be true for values to be shown. (visibleValues does not override this -- even if a value is listed there, it is still hidden if it does not meet the condition.) Condition values that refer to ranges in A1-notation are evaluated relative to the pivot table sheet. References are treated absolutely, so are not filled down the pivot table. For example, a condition value of =A1 on "Pivot Table 1" is treated as 'Pivot Table 1'!$A$1. The source data of the pivot table can be referenced by column header name. For example, if the source data has columns named "Revenue" and "Cost" and a condition is applied to the "Revenue" column with type NUMBER_GREATER and value =Cost, then only columns where "Revenue" > "Cost" are included.
  • visibleByDefault (type: boolean(), default: nil) - Whether values are visible by default. If true, the visible_values are ignored, all values that meet condition (if specified) are shown. If false, values that are both in visible_values and meet condition are shown.
  • visibleValues (type: list(String.t), default: nil) - Values that should be included. Values not listed here are excluded.

Summary

Types

t()

Functions

decode(value, options)

Unwrap a decoded JSON object into its complex fields.

Types

t()

@type t() :: %GoogleApi.Sheets.V4.Model.PivotFilterCriteria{
  condition: GoogleApi.Sheets.V4.Model.BooleanCondition.t() | nil,
  visibleByDefault: boolean() | nil,
  visibleValues: [String.t()] | nil
}

Functions

decode(value, options)

@spec decode(struct(), keyword()) :: struct()

Unwrap a decoded JSON object into its complex fields.