class Google::Apis::SheetsV4::DateTimeRule
Allows you to organize the date-time values in a source data column into buckets based on selected parts of their date or time values. For example, consider a pivot table showing sales transactions by date: ----------
——– ——+ | Date | SUM of Sales | ----------
————–+ | 1/1/2017 | $621. 14 | | 2/3/2017 | $708.84 | | 5/8/2017 | $326.84 | … ----------
———— –+ Applying a date-time group rule with a DateTimeRuleType of YEAR_MONTH results in the following pivot table. --------------
————–+ | Grouped Date | SUM of Sales | --------------
————–+ | 2017-Jan | $53, 731.78 | | 2017-Feb | $83,475.32 | | 2017-Mar | $94,385.05 | … +————- ---------------
Attributes
The type of date-time grouping to apply. Corresponds to the JSON property `type` @return [String]
Public Class Methods
# File lib/google/apis/sheets_v4/classes.rb, line 4374 def initialize(**args) update!(**args) end
Public Instance Methods
Update properties of this object
# File lib/google/apis/sheets_v4/classes.rb, line 4379 def update!(**args) @type = args[:type] if args.key?(:type) end