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