class Google::Apis::SheetsV4::ManualRule

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 | … -----------—- —————+

Attributes

groups[RW]

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` @return [Array<Google::Apis::SheetsV4::ManualRuleGroup>]

Public Class Methods

new(**args) click to toggle source
# File lib/google/apis/sheets_v4/classes.rb, line 6534
def initialize(**args)
   update!(**args)
end

Public Instance Methods

update!(**args) click to toggle source

Update properties of this object

# File lib/google/apis/sheets_v4/classes.rb, line 6539
def update!(**args)
  @groups = args[:groups] if args.key?(:groups)
end