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

Inherits:
Object
  • Object
show all
Includes:
Core::Hashable, Core::JsonObjectSupport
Defined in:
generated/google/apis/sheets_v4/classes.rb,
generated/google/apis/sheets_v4/representations.rb,
generated/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

Methods included from Core::JsonObjectSupport

#to_json

Methods included from Core::Hashable

process_value, #to_h

Constructor Details

#initialize(**args) ⇒ DateTimeRule

Returns a new instance of DateTimeRule.



4163
4164
4165
# File 'generated/google/apis/sheets_v4/classes.rb', line 4163

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)


4161
4162
4163
# File 'generated/google/apis/sheets_v4/classes.rb', line 4161

def type
  @type
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



4168
4169
4170
# File 'generated/google/apis/sheets_v4/classes.rb', line 4168

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