Class: Google::Apis::SheetsV4::ManualRule

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

Allows you to manually organize the values in a source data column into buckets with names of your choosing. For example, a pivot table that aggregates population by state: +-------+-------------------+ | State | SUM of Population | +-------+-------------------+ | AK | 0.7 | | AL | 4.8 | | AR | 2.9 | ... +-------+-------------------+ could be turned into a pivot table that aggregates population by time zone by providing a list of groups (for example, groupName = 'Central', items = ['AL', 'AR', 'IA', ...]) to a manual group rule. Note that a similar effect could be achieved by adding a time zone column to the source data and adjusting the pivot table. +-----------+-------------------+ | Time Zone | SUM of Population | +-----------+-------------------+ | Central | 106.3 | | Eastern | 151.9 | | Mountain | 17.4 | ... +-----------+-------------------+

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) ⇒ ManualRule

Returns a new instance of ManualRule



5599
5600
5601
# File 'generated/google/apis/sheets_v4/classes.rb', line 5599

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

Instance Attribute Details

#groupsArray<Google::Apis::SheetsV4::ManualRuleGroup>

The list of group names and the corresponding items from the source data that map to each group name. Corresponds to the JSON property groups



5597
5598
5599
# File 'generated/google/apis/sheets_v4/classes.rb', line 5597

def groups
  @groups
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



5604
5605
5606
# File 'generated/google/apis/sheets_v4/classes.rb', line 5604

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