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

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
lib/google/apis/sheets_v4/classes.rb,
lib/google/apis/sheets_v4/representations.rb,
lib/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

Constructor Details

#initialize(**args) ⇒ PivotGroupSortValueBucket

Returns a new instance of PivotGroupSortValueBucket.



7511
7512
7513
# File 'lib/google/apis/sheets_v4/classes.rb', line 7511

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



7503
7504
7505
# File 'lib/google/apis/sheets_v4/classes.rb', line 7503

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)


7509
7510
7511
# File 'lib/google/apis/sheets_v4/classes.rb', line 7509

def values_index
  @values_index
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



7516
7517
7518
7519
# File 'lib/google/apis/sheets_v4/classes.rb', line 7516

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