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
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
# File lib/google/apis/sheets_v4/classes.rb, line 6534 def initialize(**args) update!(**args) end
Public Instance Methods
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