Class: Google::Apis::SheetsV4::DateTimeRule

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 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 | ... +------------- -+--------------+

Instance Attribute Summary collapse

Instance Method Summary collapse

Constructor Details

#initialize(**args) ⇒ DateTimeRule

Returns a new instance of DateTimeRule.



4468
4469
4470
# File 'lib/google/apis/sheets_v4/classes.rb', line 4468

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

Instance Attribute Details

#typeString

The type of date-time grouping to apply. Corresponds to the JSON property type

Returns:

  • (String)


4466
4467
4468
# File 'lib/google/apis/sheets_v4/classes.rb', line 4466

def type
  @type
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



4473
4474
4475
# File 'lib/google/apis/sheets_v4/classes.rb', line 4473

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