Class: Google::Apis::SheetsV4::HistogramRule

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 numeric values in a source data column into buckets of a constant size. All values from HistogramRule.start to HistogramRule.end are placed into groups of size HistogramRule.interval. In addition, all values below HistogramRule.start are placed in one group, and all values above HistogramRule.end are placed in another. Only HistogramRule.interval is required, though if HistogramRule.start and HistogramRule.end are both provided, HistogramRule.start must be less than HistogramRule.end. For example, a pivot table showing average purchase amount by age that has 50+ rows: +-----+-------------------+ | Age | AVERAGE of Amount | +-----+-------------------+ | 16 | $27.13 | | 17 | $5.24 | | 18 | $20.15 | ... +-----+-------------------+ could be turned into a pivot table that looks like the one below by applying a histogram group rule with a HistogramRule.start of 25, an HistogramRule.interval of 20, and an HistogramRule.end of 65. +-------------+-------------------+ | Grouped Age | AVERAGE of Amount | +-------------+-------------------+ | < 25 | $19.34 | | 25-45 | $31.43 | | 45-65 | $35.87 | | > 65 | $27.55 | +-------------+-------------------+ | Grand Total | $29.12 | +-------------+-------------------+

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) ⇒ HistogramRule

Returns a new instance of HistogramRule.



6060
6061
6062
 
# File 'generated/google/apis/sheets_v4/classes.rb', line 6060

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

Instance Attribute Details

#end ⇒ Float

The maximum value at which items are placed into buckets of constant size. Values above end are lumped into a single bucket. This field is optional. Corresponds to the JSON property end

Returns:

  • (Float) 


6046
6047
6048
 
# File 'generated/google/apis/sheets_v4/classes.rb', line 6046

def end
  @end
end

#interval ⇒ Float

The size of the buckets that are created. Must be positive. Corresponds to the JSON property interval

Returns:

  • (Float) 


6051
6052
6053
 
# File 'generated/google/apis/sheets_v4/classes.rb', line 6051

def interval
  @interval
end

#start ⇒ Float

The minimum value at which items are placed into buckets of constant size. Values below start are lumped into a single bucket. This field is optional. Corresponds to the JSON property start

Returns:

  • (Float) 


6058
6059
6060
 
# File 'generated/google/apis/sheets_v4/classes.rb', line 6058

def start
  @start
end

Instance Method Details

#update!(**args) ⇒ Object

Update properties of this object



6065
6066
6067
6068
6069
 
# File 'generated/google/apis/sheets_v4/classes.rb', line 6065

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