Class: Google::Apis::SheetsV4::PivotGroupSortValueBucket

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
generated/google/apis/sheets_v4/classes.rb,
generated/google/apis/sheets_v4/representations.rb,
generated/google/apis/sheets_v4/representations.rb

Overview

Information about which values in a pivot group should be used for sorting.

Instance Attribute Summary collapse

Instance Method Summary collapse

Methods included from Core::JsonObjectSupport

#to_json

Methods included from Core::Hashable

process_value, #to_h

Constructor Details

#initialize(**args) ⇒ PivotGroupSortValueBucket

Returns a new instance of PivotGroupSortValueBucket



1730
1731
1732
# File 'generated/google/apis/sheets_v4/classes.rb', line 1730

def initialize(**args)
   update!(**args)
end

Instance Attribute Details

#bucketsArray<Google::Apis::SheetsV4::ExtendedValue>

Determines the bucket from which values are chosen to sort. For example, in a pivot table with one row group & two column groups, the row group can list up to two values. The first value corresponds to a value within the first column group, and the second value corresponds to a value in the second column group. If no values are listed, this would indicate that the row should be sorted according to the "Grand Total" over the column groups. If a single value is listed, this would correspond to using the "Total" of that bucket. Corresponds to the JSON property buckets



1728
1729
1730
# File 'generated/google/apis/sheets_v4/classes.rb', line 1728

def buckets
  @buckets
end

#values_indexFixnum

The offset in the PivotTable.values list which the values in this grouping should be sorted by. Corresponds to the JSON property valuesIndex

Returns:

  • (Fixnum)


1716
1717
1718
# File 'generated/google/apis/sheets_v4/classes.rb', line 1716

def values_index
  @values_index
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



1735
1736
1737
1738
# File 'generated/google/apis/sheets_v4/classes.rb', line 1735

def update!(**args)
  @values_index = args[:values_index] if args.key?(:values_index)
  @buckets = args[:buckets] if args.key?(:buckets)
end