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

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

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

Constructor Details

#initialize(**args) ⇒ ManualRule

Returns a new instance of ManualRule.



6659
6660
6661
# File 'lib/google/apis/sheets_v4/classes.rb', line 6659

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



6657
6658
6659
# File 'lib/google/apis/sheets_v4/classes.rb', line 6657

def groups
  @groups
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



6664
6665
6666
# File 'lib/google/apis/sheets_v4/classes.rb', line 6664

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