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

A pivot table.

Attributes

  • columns (type: list(GoogleApi.Sheets.V4.Model.PivotGroup.t), default: nil) - Each column grouping in the pivot table.
  • criteria (type: %{optional(String.t) => GoogleApi.Sheets.V4.Model.PivotFilterCriteria.t}, default: nil) - An optional mapping of filters per source column offset. The filters are applied before aggregating data into the pivot table. The map's key is the column offset of the source range that you want to filter, and the value is the criteria for that column. For example, if the source was C10:E15, a key of 0 will have the filter for column C, whereas the key 1 is for column D. This field is deprecated in favor of filter_specs.
  • dataExecutionStatus (type: GoogleApi.Sheets.V4.Model.DataExecutionStatus.t, default: nil) - Output only. The data execution status for data source pivot tables.
  • dataSourceId (type: String.t, default: nil) - The ID of the data source the pivot table is reading data from.
  • filterSpecs (type: list(GoogleApi.Sheets.V4.Model.PivotFilterSpec.t), default: nil) - The filters applied to the source columns before aggregating data for the pivot table. Both criteria and filter_specs are populated in responses. If both fields are specified in an update request, this field takes precedence.
  • rows (type: list(GoogleApi.Sheets.V4.Model.PivotGroup.t), default: nil) - Each row grouping in the pivot table.
  • source (type: GoogleApi.Sheets.V4.Model.GridRange.t, default: nil) - The range the pivot table is reading data from.
  • valueLayout (type: String.t, default: nil) - Whether values should be listed horizontally (as columns) or vertically (as rows).
  • values (type: list(GoogleApi.Sheets.V4.Model.PivotValue.t), default: nil) - A list of values to include in the pivot table.

Summary

Types

t()

Functions

decode(value, options)

Unwrap a decoded JSON object into its complex fields.

Types

t()

@type t() :: %GoogleApi.Sheets.V4.Model.PivotTable{
  columns: [GoogleApi.Sheets.V4.Model.PivotGroup.t()] | nil,
  criteria:
    %{optional(String.t()) => GoogleApi.Sheets.V4.Model.PivotFilterCriteria.t()}
    | nil,
  dataExecutionStatus: GoogleApi.Sheets.V4.Model.DataExecutionStatus.t() | nil,
  dataSourceId: String.t() | nil,
  filterSpecs: [GoogleApi.Sheets.V4.Model.PivotFilterSpec.t()] | nil,
  rows: [GoogleApi.Sheets.V4.Model.PivotGroup.t()] | nil,
  source: GoogleApi.Sheets.V4.Model.GridRange.t() | nil,
  valueLayout: String.t() | nil,
  values: [GoogleApi.Sheets.V4.Model.PivotValue.t()] | nil
}

Functions

decode(value, options)

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

Unwrap a decoded JSON object into its complex fields.